< Go Back

Date is same month and year

How do you tell if dates share the same month a year in excel? You can test is date is some month and year very easily by applying the MONTH and YEAR functions. The functions make a perfect formula for this kind of problem. Check out how the formula looks like:

Formula

Then generic syntax for this formula is:

=MONTH(date1)&YEAR(date2)=MONTH(date1)&YEAR(date2)

Explanation

The working of the formula to check if the date is the same month and year is not as complicated as it appears. What happens is that the month number and year values are extracted from the date values in cell references like B2 and C2, and then put together in series to form a chain of text using concatenation operator Ampersand (&).. A similar thing is done of the other side of the equation where the month and year values are extracted from date values in cell references B2 and C2 are also joined together. Then, the formula is tested if both sides are equal using the equal(=) sign.

Example

Assume that you have two sets of dates and can’t tell whether they share same month and year. With Excel, checking if the date is the same month and year is very easy. To do that, we’re going to use the formula described above.

From the above example, the formula in the highlighted cell (D10) is:

=MONTH(B9)&YEAR(B9)=MONTH(C9)&YEAR(C9)

If you look at dates of row 9, you will notice that they are in January of 2011. Therefore, the formula returns TRUE. This is how the problem is solved:

=MONTH(B9)&YEAR(B9)=MONTH(C9)&YEAR(C9)

=1&2011=1&2011

=”1201”=”1201”

=TRUE

Figure 1. Example 1 of MONTH/YEAR Function

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar