using dates in XL

  conrail 20:52 15 Aug 2009
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 2009

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 2009

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.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?