Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles DATE AND TIME Date is same month

Date is same month

How do you tell if dates share the same month a year in excel? You can test is Date is same 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

Firstly, 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. Therefore, 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. The following step will present the solution:

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

=1&2011=1&2011

=”1201”=”1201”

=TRUE

Figure 1. Example 1 of MONTH/YEAR Function

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc