Hi All,
Thanks in advance for all the help. Here is my situation.
In my spreadsheet I have a start and and end date. I need to count the months included in that span. Here's the twist - I have some that span multiple months, multiple years, and some that span only a few dates in one month. I need even one day to count as a month.
i.e.
1/1/13 - 12/31/14 = 24 months
1/1/13 - 2/1/13 = 2 months
1/1/13 - 1/15/13 = 1 month (NOT ZERO)
How do I do this???????
Bookmarks