i'm working on a excel sheet, i have some products need to know how many number left.
if i set the day expire on 12/31/2012, and i enter today's date on top of the excel sheet, the NO. of day left it will automatically show me how many left still have. and if the day is less than 120 days it will automatically change to the color that i have sent. like if i set less than 120 days, it will show green on that box, less than 90 days it will show blue, less than 60 days will show orange, if less than 30 days will show red.
the formula that my friend use is DAYS360
and when i click on show formula it show me "=C5-$D$1" for the number of day left.
please help me on that... i'm new of using the excel sheet.
Thank You!
if i set the day expire on 12/31/2012, and i enter today's date on top of the excel sheet, the NO. of day left it will automatically show me how many left still have. and if the day is less than 120 days it will automatically change to the color that i have sent. like if i set less than 120 days, it will show green on that box, less than 90 days it will show blue, less than 60 days will show orange, if less than 30 days will show red.
the formula that my friend use is DAYS360
and when i click on show formula it show me "=C5-$D$1" for the number of day left.
please help me on that... i'm new of using the excel sheet.
Thank You!