Conditional Formatting by Date (Month)

[CP]

I want to format a Date Column

If Column F is less than any date from today + 1month

Meaning today being 2/9/09 anything in F that is less than 31/10/09

Any guidance please?

 

[Rick Rothstein]

I guess this Conditional Format formula will do what you want...

=AND(F1<DATE(YEAR(NOW()),MONTH(NOW())+1,DAY(NOW())),F1<>"")

 

[Luke M]

Make sure the Analysis ToolPak Add-in is activated.

Assuming you're starting in F2
Format - Conditional Format.
Formula is:
=F2<=EOMONTH(TODAY(),1)

 

[Jacob Skaria]

Your example and query contradicts..If you mean today+1month try the below

=AND(F1>0,F1<DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())))

If this post helps click Yes

 

[CP]

Ricks answer worked - was more likely my explanation was, thank you

 

[CP]

I already have the answer now thank you.

*Analysis ToolPak Add-in* - what and where is this?

 

[Luke M]

Under Tools - Add-ins, you'll see a variety of add-ins that you can choose to
activate in XL.

 

[T. Valko]

That won't work in Excel versions 2003 and earlier. You can't directly use
functions that are in the ATP.

You'd have to use a defined name.

Insert>Name>Define
Name: TargetDate
Refers to: =EOMONTH(TODAY(),1)

Then, as the formatting formula:

=F2<=TargetDate