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

[josephogk]

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

[#2]

@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?