Count days

[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

 

[Don Guillett]

where g2 is the EARLIER date
=DATEDIF(G2,G1,"D")

 

[Peo Sjoblom]

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)

 

[JulieD]

Hi Cody

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

Cheers
JulieD

 

[Norman Harker]

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.

 

[Norman Harker]

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!

 

[Daniel.M]

G'Day Norman,

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

Are-you sure you want to format the _result_ as a date? <g>

Regards,

Daniel M.