I am trying to subtract 2 dates and show the answer in months even when the dates span more than a year. I have used a datedif formula but can't get it to show the result in months only.
Appreciate any ideas anyone can provide.
I am trying to subtract 2 dates and show the answer in months even when the dates span more than a year. I have used a datedif formula but can't get it to show the result in months only.
Appreciate any ideas anyone can provide.
Try =DATEDIF(A2,B2,"m")
Wow - That simple!! Thanks I was caught in a web of convaluted formulas. Works like a dream.
As DATEDIF is not documented anymore by MS you will find info here
Excellent - Now in my bookmarks. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks