Formula depending on dates & text

  • Thread starter Thread starter amey
  • Start date Start date
A

amey

i have a spread sheet with about 11 cols in it. In the final col i nee
a formula that will display either "default" or "OS" depending on what
in other cols.

In cell H1 there is a formula (=TODAY()) to calculate todays date.
The rest of col H will contain dates, representing a target date.
Col I contains completion dates if a job has been complete else it wil
contain "not claimed".

Now i need a formula to put in col K that will show up "OS" if th
target date is greater than todays (in H1) & it says "not claimed" i
the completion date col. If there is a date in the completion date co
then it should say "default".

Any help would greatful
 
Hi

Try:
=IF(AND(H2>$H$1,I2="not claimed"),"OS","default")
and fill down

You could do away with having the formula in H1 and use:
=IF(AND(H2>today(),I2="not claimed"),"OS","default")
 
Back
Top