Hello
I am trying to figure out if there is a way I can calculate "number of months" between two dates , but display it year wise.
For example, I have Start Month as "Aug-18" in A1 and Current Month automatically displayed as "Oct-20" in B1. When I use DATEDIF function, it gives me 26 as number of months.
I am trying to achieve a way where I can have yearwise split of no. of months i.e.
2018 - 4
2019 - 12
2020 - 10
I am having a different monthly rate for each year, which I want to apply to no. of months in that year to calculate accrued amount, hence the split.
Here's the example:
2018 - 4 * 7000 = 28,000
2019 - 12 * 7500 = 90,000
2020 - 10 * 8000 = 80,000
Can anyone suggest a way I can get number of months by the calender year?
Thanks
I am trying to figure out if there is a way I can calculate "number of months" between two dates , but display it year wise.
For example, I have Start Month as "Aug-18" in A1 and Current Month automatically displayed as "Oct-20" in B1. When I use DATEDIF function, it gives me 26 as number of months.
I am trying to achieve a way where I can have yearwise split of no. of months i.e.
2018 - 4
2019 - 12
2020 - 10
I am having a different monthly rate for each year, which I want to apply to no. of months in that year to calculate accrued amount, hence the split.
Here's the example:
2018 - 4 * 7000 = 28,000
2019 - 12 * 7500 = 90,000
2020 - 10 * 8000 = 80,000
Can anyone suggest a way I can get number of months by the calender year?
Thanks