Count days formula

  • Thread starter Thread starter josh
  • Start date Start date
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
 
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
 
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)
 
=B1-A1
will return the number of days between 2 dates in A1 and B1
Click to expand...

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
 
Back
Top