If the date is in A1... and you enter Jan (or whatever..) in B1, this will return TRUE if the months match, otherwise it'll return FALSE. So exactly, what do you want it to do when there is/isn't a match??
=MONTH(A1)=MONTH(1&B1)
If the date is in A1... and you enter Jan (or whatever..) in B1, this will return TRUE if the months match, otherwise it'll return FALSE. So exactly, what do you want it to do when there is/isn't a match??
=MONTH(A1)=MONTH(1&B1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks