Try this:

If you date cell is C2 and it contains the true Excel date of 25-Aug-05, in
a cell next to that enter this formula:

=OR(MONTH(C2)=MONTH(TODAY()),MONTH(TODAY())-1=MONTH(C2))

What result do you get?

Biff

"viddom" wrote in message
...
Dear Biff,

my computer do the same, but still the cell format do not change. If I
have
to generate some code, lI will be pleased to have some example

"Biff" wrote:

Are you sure that 25aug05 is being recognized as a TRUE EXCEL DATE?

It looks like a TEXT string to me!

In my version of Excel if I type in 25aug05, Excel converts that string
to
25-Aug-05 which is a TRUE EXCEL DATE.

Select the "date" cell and then goto FormatCellsNumber. Select GENERAL.
Does the Sample box show 38589? If not then 25aug05 is a text string.

Biff

"viddom" wrote in message
...
Guys, I don't know what I am doing wrong,cause I tried the conditional
formatign with each formula, but when I put a date like 25aug05 the
cell
do
not change a format. What step I am missing?


"cgarrett1999" wrote:

This seems to work also.

Position the cursor over the cells where the date is.

Conditional formatting,
Condition1 "Cell Value Is" "between" "=today()" and "=today()+30"
Format the cell to be color = "yellow"