If statements using dates.

[MikeyZ]

I am using this IF
=IF(P518<=TODAY(),"Late","")

I would likw to modify it so that any date which is 3 days prior to TODAY() will be flagged.
any suggestions?

 

[sark666]

Just use =IF(P518<=TODAY()-3,"Late","")

 

[MikeyZ]

I did try that but the flag didn't work.

The flag would need to work so that anything covering the range from today -3, would flag.
Would the OR work to cover the range of 3 days?

 

[MikeyZ]

I tried to get cute, but this didn't work:

=IF(P518<=(TODAY():Today()-3),"Late","")

Logically it should have.

 

[MikeyZ]

This worked, unless there's a better way:

=IF(OR(P518=TODAY(),P518=TODAY()-1, P518=TODAY()-2),"Late","")

 

[MikeyZ]

I went to nesting the IF and it worked.
Thanx. no need to REPLY.

 

[sark666]

I tried what I typed and it did work for me. Today()-3 so I can't say off-hand why that didn't work for you, but it sounds like you found a solution.