using dates in XL

  conrail 20:52 15 Aug 09
Locked

using vista home premium 64bit with office xp, I remember a thread here where one can set 2 dates, ie 4th march 08 and 20 july 09 and find out how many weeks/months/days between them, have done a search but cannot find info, can anybody point me in the right direction please, thanks

  VoG II 08:23 16 Aug 09

With earlier date in A1

=DATEDIF(A1,B1,"y")&" y "&DATEDIF(A1,B1,"ym")&" m "&DATEDIF(A1,B1,"md")&" d"

  conrail 14:36 19 Aug 09

thank you VoG™, sorry about the delay in replying, been working away from home

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced