# Calculate year month day between 2 dates assuming 365 days a year and 30 days a month

Copper Contributor

# Calculate year month day between 2 dates assuming 365 days a year and 30 days a month

Hi, I need to calculate the year month day between 2 dates assuming 365 days a year and 30 days a month (i.e. ignore leap year, ignore the fact that certain months have 30 days while others have 31 days).

I have been using the data calculation formulas but couldn't tally with the end date reason being it automatically included the extra days and months with more days.

My expected output, hope to seek some guidance here.

 Start Date End Date Year Month Day 31 Jan 2020 30 Jan 2022 2 0 0 1 Feb 2020 31 Mar 2022 2 2 0 15 Jun 2020 14 Apr 2022 1 10 0 1 Feb 2020 5 Apr 2022 2 2 5
1 Reply

# Re: Calculate year month day between 2 dates assuming 365 days a year and 30 days a month

I don't understand the number of days in your examples.

2*360 days + 0*30 days after 31-Jan-20 is 20-Jan-22. That leaves 10 days to 30-Jan-20.

2*360 days + 2*30 days after 01-Feb-20 is 22-Mar-22. That leaves 9 days to 31-Mar-22.

Can you explain?