Hello

I am trying to generate a formula which will give me a "Yes" answer if a date in a cell is in the same month and year as a date in a second cell and a "No" answer if it isn't. The day of the month is irrelevant. Assume date 1 is in Cell A1 and date 2 is in cell B2.

Thanks.



Taryn

=and(year(a1)=year(b2),month(a1)=month(b2))

Alternatively =if(eomonth(a1)=eomonth(b2),"yes","no")

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your help.