Substracting Dates.

I want excel to count the # of days between 01/20/2006 and 02/28/2006

Hello exsam21,

Example:
A1 = 01/20/2006
A2 = 02/28/2006
A3 = A2-A1

Format A3 as NUMBER with no decimal places. This will be the number of days.

Sincerely,
Leith Ross

Just subtract one from the other. Excel stores dates as days since 1str jan
1900, so a simple subtraction suffices.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"exsam21" <exsam21.21y6am_1137784201.9521@excelforum-nospam.com> wrote in
message news:exsam21.21y6am_1137784201.9521@excelforum-nospam.com...
>
> I want excel to count the # of days between 01/20/2006 and 02/28/2006
>
>
> --
> exsam21
> ------------------------------------------------------------------------
> exsam21's Profile:
http://www.excelforum.com/member.php...o&userid=22666
> View this thread: http://www.excelforum.com/showthread...hreadid=503455
>