Hi,
I've been trying to sort a formula to work out the number of months between 2 dates. The number must include the 1st month and the last. It also must be able to work between years. I'll give some examples
1/5/14 - 1/9/14 = 5 months
1/10/14 - 1/4/15 = 7 months
1/5/15 - 1/4/16 = 12 months
I've come close with some furmula's I've found googling but none seem to work quite right.
Any help will be much appreciated.
Ant
Bookmarks