That formula didn't work for me (it is plain wrong), and I can't see why the
OR, but this worked

=IF(AND(MONTH(TODAY())=MONTH(G5)+4,YEAR(TODAY())=Y EAR(G5)),"yes","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wzbell" wrote in
message ...

Please provide any help you can...

I am working on a spreadsheet that identifies due dates including year
and reports back yes if the criteria is met. I have a formula that
works but I can't figure out how to add the year in. Here's what I
have so far for one cell (multiplied several times for a range of cells
in actual spreadsheet):

IF(OR(MONTH(TODAY())=(MONTH(G5)+4)"yes","")

This works ok but cannot not distinguish between years. What should I
add?


--
Wzbell
------------------------------------------------------------------------
Wzbell's Profile:
http://www.excelforum.com/member.php...o&userid=37890
View this thread: http://www.excelforum.com/showthread...hreadid=574291