Biff,

I finally got it to work, just needed to understand it.
THANKS, so for your help.

JK


"Biff" wrote in message
...
Ooops!

and if the H37+3 is in April and not in March I want nothing displayed
also

Try this in that case:

=IF(AND(MONTH(H37)=3,YEAR(H37)=2005),IF(MONTH(H37+ 3)3,"",H37+3),"")

Biff

"Biff" wrote in message
...
Hi!

Try this:

=IF(AND(MONTH(H37)=3,YEAR(H37)=2005),MIN(H37+3,DAT E(2005,3,31)),"")

Format the cell as DATE

Biff

"Jerry Kinder" wrote in message
...
Hi,
My formula:
IF($H$37<MONTH(3)*YEAR(2005),"",$H$37+3)
IF H37 is less than or grater than March 2005 (not in March) then,
display
nothing, elae (if it is in March)display the date+3. I want it to
display
a
date in March only not in any other month.

H37 has March 26, 2005 in it. I want the formula cell to display March
29th.

If H37 has no date I want the formula cell to display nothing and if
the
H37+3 is in April and not in March I want nothing displayed also,
diaplay
only if the +3 is a date in March.

What I get with the above is nothing if there is a date in March.

When I change the formula to the following I get the correct date but
this
is wrong:

IF($H$37<MONTH(3)*YEAR(2005),$H$37+3,"")

SO what have I done?? What should I do!

Thank you,
JK