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