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

Copper Contributor

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 DateEnd DateYearMonthDay
31 Jan 202030 Jan 2022200
1 Feb 202031 Mar 2022220
15 Jun 202014 Apr 20221100
1 Feb 20205 Apr 2022225
1 Reply

@josephogk 

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?