Hi all,
I want to know how many months from two dates are known using the day, date or month function assuming 1 month = 30 days.
Please kindly help . Attachment already attached.
thank you
regard
dolphino
Hi all,
I want to know how many months from two dates are known using the day, date or month function assuming 1 month = 30 days.
Please kindly help . Attachment already attached.
thank you
regard
dolphino
use datedif:
=datedif(1st day of start date month,1st day of due date month,"m")+1
Please Login or Register to view this content.
Quang PT
On your sheet, you say the result should be 33 based on the count of (used cells) in c12:C44. However, Calculating the number of months from 10/31/2020 to 6/14/2023 returns 32 because you are starting from the end of the month 10/31, October is already passed...?
Ben Van Johnson
dear Ben,
yes true, it's really over the date (31 oct 20), but still the period in October 2020 I need to calculate. so the desired value is 33 months. thank you before
regard
dophino
dear bebo021999,
thanks for the information, I can use the formula . thank you.
Regard
dolphino
If DATE(y1,m1,31) to DATE(y2,m2,1) should include full months for both dates, e.g., 31 Oct 2020 to 1 Nov 2020 should be 2 months, maybe
=DATEDIF(B5-DAY(B5),EOMONTH(B6,0),"m")
Try this
=(YEAR(B6)-YEAR(B5))*12+MONTH(B6)-MONTH(B5)+1
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
dear hrlngrv
thank you for your information, working in my file.
regard
dolphino
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks