Write a formula to check if two dates are in same month? [homework]
Its Home work time folks. Sharpen your Excel pencils and get cracking.
Find out if 2 dates are in same month
Lets say you have 2 dates in A1, A2.
Q1. What formula tells us if both of them are in same month?
Both dates must be in same month & year!
Go ahead and post your answer in comments.
You think that was easy, try this then:
The above formula would be very easy for seasoned Excel pros. So I have 2 additional questions:
Q2. How to find out if n dates (A1:An) are in same month?
Q3. How to find if n dates (A1:An) are in a given date range – start date in B1, end date in B2?
Post your answers in comments
Go ahead and post your answers in comments. I am eager to see what creative, fun & awesome solutions you can come up with for this problem.
PS: Click here for more Excel home works, quizzes & challenges.
Clue: Click here for a clue. Got it?
Sign-up for our FREE Excel tips newsletter:
Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|Journey of Hurricane Sandy – Animated Excel Chart||Show monthly values & % changes in one pivot table|