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.

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:
Solution examples
how do I derive the monthly sales from a date and revenue column
Solved by A. U. in 23 mins
I want to be able to alter the appearance (font color and fill) of a column of numbers using conditional formatting, based on being greater than or less than the numbers from another column. I am using Excel 2016. I am unable to get any formula to work. Please help!
Solved by I. J. in 59 mins
I need assistance with an excel formula. I have a 12 month sheet that has a summary page on the 13 page. the monthly totals changes so on the summary page I want to sum the difference - eg. if Jan total is 1500, feb total is 1000, mar total is 800, I want the summary page to show the current amount of 800 when you place the formula to capture all months---showing the diminishing value rather than the sum of all the pages
Solved by E. L. in 60 mins
I need a range of numbers to become the number in the next column
Solved by D. F. in 47 mins
Use the Vlookup Function to complete the "employee" column of table 2. Use "job Id" from table 2 as your lookup_value(s) and table 1 as your reference.
Solved by C. H. in 16 mins

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