Date Formula

  steviegee 13:33 10 Mar 09

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 09

click here Should do it for you.

  VoG II 13:40 10 Mar 09

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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…