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

[image] Man: I’m trying to calculate the number of months between two dates (startDate and endDate). 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-…

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

VinayakUpadhyay July 10, 2024, 3:04pm 10

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

Topic		Replies	Views
Count the months between 2 dates Questions date-time-functions	7	1772	August 18, 2023
Enum Dates between start and end date Questions functions , arrays , date-time-functions	3	390	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