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

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique