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

=AND(F10,F1<DATE(YEAR(TODAY()),MONTH(TODAY())+1,D AY(TODAY())))

If this post helps click Yes
---------------
Jacob Skaria


"CP" wrote:

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?