TODAY()+3 OR later syntax

ddub25

Well-known Member
Joined
Jan 11, 2007
Messages
625
Office Version
  1. 2019
Platform
  1. Windows
=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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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
 
Upvote 0
[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
 
Upvote 0
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?
 
Upvote 0
AJ18<=TODAY()+3

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

Dan
 
Upvote 0

Forum statistics

Threads
1,222,310
Messages
6,165,265
Members
451,949
Latest member
bovacik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top