Hi,
For my interest calculations, i need to know the numbers of months for the specific year, which is valid between two dates.
Start Date : 01-May-2016
End Date : 10-Apr-2021
What formula/function i should use, if i want to know number of months for 2017?
eg.
if i select the year, i should know the number of the months for the respective year, like below
Year - Months
2016 - 7
2017 - 12
2019 - 12
2021 - 4
Could any one please advice me to find this?
Thanks in advance.
Regards,
Kalaiselvan
Bookmarks