# Calculating days gone by in EXCEL 2002

aph 18:43 01 Jul 03
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 03

Have you formatted the cells as date?

VoG II 18:58 01 Jul 03

=DATEDIF(A2,A1,"d")

VoG II 19:08 01 Jul 03

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.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

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

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…