Calculating days gone by in EXCEL 2002

  aph 18:43 01 Jul 2003
Locked

I want to calculate how many days there are between two different dates and have it as a whole number

e.g.
in the cell I type
(where A1 is 17/06/03 and A2 is 13/06/2003)
=A1-A2

I get a rather large number whereby I was expecting a value of 4 !!

All help welcome

Louise

  graham√ 18:58 01 Jul 2003

Have you formatted the cells as date?

  VoG II 18:58 01 Jul 2003

=DATEDIF(A2,A1,"d")

  VoG II 19:08 01 Jul 2003

Actually if you use =A1-A2 it should work as long as A1 and A2 are formatted as dates and the answer cell is formatted as number.

If you are getting a number like 37789 (the date serial number for 17/06/03) then you are referencing the wrong cell(s) in your formula.

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

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?