Forum Discussion
josephogk
Apr 21, 2023Copper 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
Sort By
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?