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