Count days formula

[josh]

What is the name of the function that counts the days
between two dates? thanks

 

[William]

Hi josh

=B1-A1
will return the number of days between 2 dates in A1 and B1

--
XL2002
Regards

William

(e-mail address removed)

| What is the name of the function that counts the days
| between two dates? thanks

 

[JulieD]

this is beginning to look like homework = "Cody" asked the same question
about half an hour ago
summary of answers:
Don Guillett
where g2 is the EARLIER date
=DATEDIF(G2,G1,"D")

Peo Sjoblom
No name function, just subtract
=End-Start

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

Norman Harker
With dates that are recognised as dates by Excel
=LatestDate-EarliestDate
format as number

Cheers
JulieD

 

[Peo Sjoblom]

Are you Cody?

To count days just subtract as earlier stated, there is a function called
DAYS360
which counts days based on 30 day months

--

Regards,

Peo Sjoblom

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

 

[Cody]

Just subtract the two dates and format it to Number.

 

[Harald Staff]

=B1-A1
will return the number of days between 2 dates in A1 and B1

If I may be very picky; it will return the difference in days between the
two. There are no days BETWEEN yesterday and today, the difference is 1 day.
=B1-A1 will return 1 in this case.

Best wishes Harald