Hello, I could use some assistance with an automation , I’m trying to calculate the number of months between two dates (startDate and endDate). Thank you in advance for your help!

yes @Man , You are right If the year is different then we can do that in this way [image] [image] [image] By doing this you will get the desired result [image] blueprint (12).json (7.7 KB)

Hey @Man , Welcome to the community. You can get the count of the month using [image] [image] And then you can simply subtract them [image] [image]

Thank you for your response @VinayakUpadhyay . This method cannot work in all cases. It is only valid when the start and end dates are within the same year. For instance, if the start date is 05/06/2022 and the end date is 05/06/2024, it cannot work.

thank you very much @VinayakUpadhyay I just have one last question and when I want to calculate the total number of months between these dates how should I do it

@Man , Check the above reply now

Thank u so much @VinayakUpadhyay it works

@Donald_Mitchell Amazing! That was a more optimized way of doing that.

Yes, but I think there will be some edge cases that may not work out correctly/as expected. There are different ways to interpret “Number of months between two dates”. For example, is 1 month = 30 days? Therefore you need to determine the number of days then divide by 30? That won’t always work. …

Need Help Calculating Months Between Two Dates

Questions

Donald_Mitchell July 10, 2024, 3:01pm 9

Make documentation has another way of doing this as well. Just adjust the calculation for which output you need.
https://www.make.com/en/help/functions/date---time-functions#how-to-calculate-days-between-dates

Topic		Replies	Views
Count the months between 2 dates Questions date-time-functions	7	1768	August 18, 2023
Enum Dates between start and end date Questions functions , arrays , date-time-functions	3	388	November 20, 2023
Calculate utilization days in a given month from a start date and end date (Or timeline) Questions filters , functions , monday	3	356	June 25, 2024
Two dates range comparison - ClickUp Make Questions	3	963	July 21, 2023
How to get the last month's range? Questions date-time-functions	4	780	November 14, 2023

Need Help Calculating Months Between Two Dates

Related topics