Here is my solution for calculating months between two dates:
(((Date.Year([Finish Date]) - Date.Year([Start Date]))-1)*12)+(12-Date.Month([Start Date]))+(Date.Month([Finish Date]))
Here is my solution for calculating months between two dates:
(((Date.Year([Finish Date]) - Date.Year([Start Date]))-1)*12)+(12-Date.Month([Start Date]))+(Date.Month([Finish Date]))
Posting Permissions
Reply With Quote