Microsoft Excel - How to formulate warnings when expiry date was given.

Hello,

I am using Excel 2010 pack. I have difficulties in creating the formula for my worksheet.

I want to know if we're given the date of issuance and it's expiry date, how to make a formula which will indicate how many days left before it get expire plus with the warning? How to make the expiry date column auto remind example in color? Let's say if it's about to be expiry in 10 days the column shall turn to red.

Above is the example how I want it to be formulated:

One way of doing it is by using conditional formatting.  Select the cell(s) that you want to format, go to menu Format->Conditional Formatting, and enter a "Formula Is" condition with a formula similar to:
=(A1-TODAY())<30
Change the cell address to the selected cell.  You can use the Format button on the condition to define how you want the warning to be (red shade, for example).

Hope this helps,

a combination of some excel function and it could be achived

try using conditional formatting, DateDif, and a additional column

also for getting the warning you can make use of macro.

hope this helps

Hi Kalpana,

Nothing seems to work :(

Noni,

You simply need to change your date formatting to something excel can understand, I bet you are getting a
#VALUE! error. 

I formattted the date to custome yy/mm/dd and even tried to use =ABS( for the absolute value fo the cells but until i changed the date format so i could use =G4-today() it would not work. 

So look at your date format and then use Semesh's conditional formatting to change the color when it gets close to expire. 





HTH

Don