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

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503455

If 1/20/2006 is in cell A1 and 2/28.2006 is in cell B1 the formula would
be
=TEXT((B1-A1),"#")

;)


--
Fable


------------------------------------------------------------------------
Fable's Profile: http://www.excelforum.com/member.php...fo&userid=2185
View this thread: http://www.excelforum.com/showthread...hreadid=503455

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" wrote in
message ...

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