Count days

  • Thread starter Thread starter Cody
  • Start date Start date
C

Cody

how do i count the number of days between two dates. like
between 11/06/03 and 3/09/04. what is the name of the
function. thanks
 
No name function, just subtract


=End-Start

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi Cody

you can just do a subtraction formula
=B1-A1
and format the result as "Number"

Cheers
JulieD
 
Hi!

With dates that are recognised as dates by Excel

=LatestDate-EarliestDate
Format (eg) dd-mmm-yyyy

(eg)

=B1-A1
Format (eg) dd-mmm-yyyy

Excel uses a date serial number system whereby dates are the number of
days from a base date of 31-Dec-1899. Since they are numbers that are
merely formatted to appear as dates, you get away with deducting the
earliest from the latest.
 
Doh!

Time for bed! Format as a number. What I wanted to point out was that
the return of B1-A1 will usually be in a date format that you have to
over-ride with a number format.

Good night!
 
Back
Top