Thread
:
How do I display months and years between two dates
View Single Post
#
2
Don Guillett
Posts: n/a
later date in f5, earlier in f4
=DATEDIF(F5,F4,"m")
--
Don Guillett
SalesAid Software
"JSmith" wrote in message
...
I need to display the months and years between two dates in two separate
fields.
I want a result such as 3 months, 2 years with months in B1 and years in
B2.
Any suggestions? Thank you!
Reply With Quote