Hello,
I am sure this is a relatively simple fix, but I haven't been able to solve through google searches. Does anyone know how I can return the number of months between two dates?
I have been using the DatedIf function (startdate, enddate, "m"), but it returns #value!.
I attach an example file.
I appreciate any help that can be provided.
Thank you.
In D2 and E2 you've text date not excel date. Re-type 01/01/2017 and 01/01/2018 . F2 format General
or
you can use Custom format (dd.mm.yy) to see 01.01.17 but you should type date like above.
see att.
Last edited by sandy666; 05-03-2017 at 07:43 PM. Reason: att added
replace the . to / and you have date format
Kind regards
Leo
Thank you!!
I should have figured that out on my own.
All the best.
You are welcome
If problem is resolved read my "dancing" footnote
Thanks for rep and mark thread as solved
Have a nice day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks