Compare month and year in Excel dates (ignore the day)
00:00 Compare dates (month and year only, the day is irrelevant) 00:20 Build an IF function that compares the dates 00:55 Use EOMONTH to make all dates have the same day, month & year to compare 01:47 Explaining EOMONTH in more detail How to easily compare 2 dates where you are only concerned about the month and year matching, the day is not important in this case. This is a much easier way then building an AND function into an IF function.
00:00 Compare dates (month and year only, the day is irrelevant) 00:20 Build an IF function that compares the dates 00:55 Use EOMONTH to make all dates have the same day, month & year to compare 01:47 Explaining EOMONTH in more detail How to easily compare 2 dates where you are only concerned about the month and year matching, the day is not important in this case. This is a much easier way then building an AND function into an IF function.