Hi
I am trying to find a formula that will calcualte the number of months between 2 dates but, will also take into account some other rules. For example: if the second date has a day of less the 15 it would calculate that month as 0.5 and if the day is over 15 it will calculate the month as a full month.
Start Date: 01.01.2014
End Date: 14.06.2014
Months worked: 5.5
Start Date: 01.01.2014
End Date: 15.06.2014
MOnths worked: 6
Any help would be really appriciated.
Bookmarks