View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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!