date counting

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Hi All
I am trying to figure out a formula that will count the number of days from
a date to a date
Example:
1-10-04 to 2-10-04 = 32 days
Any ideas?

Tia

Roy
 
Roy

=B1-A1+1

where the later date is in cell B1 and the earlier date is in A1. Format
the cell as General

Regards

Trevor
 
Hi Roy!

From your example:

To count inclusive of both dates:
=B1-A1+1

To count exclusive of both dates:
=B1-A1-1

To count how many days the second is from the first:
=B1-A1

=DATEDIF(A1,B1,"d")
Uses the third method

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top