TODAY()+3 OR later syntax

[ddub25]

=AJ18=TODAY()+3

I am using this for conditional formatting but want it to also apply to days beyond TODAY()+3.

Can anyone help with the correct expression? Thanks.

Dan

 

[barry houdini]

If you mean you want to format any date that's 3 days in the future or more then change = to >=, i.e.

=AJ18>=TODAY()+3

 

[Cease]

I just tried this out and it seems to do the trick:
=AJ18>=TODAY()+3

 

[ddub25]

[sorry, this initial post was not very clear]

=AJ18=TODAY()+3

I am using this formula to highlight cells 'RED' that are 3 days before todays date. I want them to remain red from this time onwards.

Can anyone help with the correct expression? Thanks.

Dan

 

[barry houdini]

Your formula will format future dates but you mention "3 days before todays date". Can you give an example, today is 3rd March 2011, which dates would be formatted today?

 

[ddub25]

AJ18<=TODAY()+3

Thanks, I got a bit confused. I've changed it to '<' and it does exactly what I want. Thanks.

Dan