Date Formula

  steviegee 13:33 10 Mar 2009

If I have one date in one cell and anoother date in another cell what is the formula to give me the amount of days between the 2? Thanks.

  Taff™ 13:39 10 Mar 2009

click here Should do it for you.

  VoG II 13:40 10 Mar 2009

You can just subtract one from the other and format the result cell as number.


=DATEDIF(first, second,"d")

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

Elsewhere on IDG sites

Best Black Friday Deals 2017

Black Friday Deals for Designers & Artists: Adobe, Apple, Corel Painter, Microsoft Surface, Wacom &e…

Best Black Friday Apple Deals 2017

Black Friday 2017 : date, sites participants & bonnes affaires