Hi
try the following in P1
=IF(O1="","",IF(O1=TODAY(),O1-TODAY(),"Expired"))
-----Original Message-----
in column O i have a date in format dd/mm/yy. In column
P I want to put
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 from
today
if date in O IS in the past then cell value = "Expired"
I already have conditional formatting set up to colour
the cells in
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 to
work properly hehe
Thanks
---
Message posted from http://www.ExcelForum.com/
.