Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need formula to set value based on a date
in column O i have a date in format dd/mm/yy. In column P I want to pu
a formula to say: if O is blank then do nothing if date in O is not in the past then cell value= number of days fro today if date in O IS in the past then cell value = "Expired" I already have conditional formatting set up to colour the cells i based on the date, so now I just need to fill them in. I know its not hugely difficult, I just cant ever get the formulas t work properly hehe Thank -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula based on the lastest date for date | Excel Discussion (Misc queries) | |||
Formula based on Date | Excel Worksheet Functions | |||
Earlest Date Based On A Date Using Min Formula | Excel Discussion (Misc queries) | |||
Need to create formula based on date | New Users to Excel | |||
Convert formula to value based upon date | Excel Discussion (Misc queries) |