software

I want excel to count the # of days between 01/20/2006 and 02/28/2006--
exsam21
------------------------------------------------------------------------
exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
View this thread: 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: www.excelforum.com/member.php...oamp;userid=18465
View this thread: 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),quot;#quot;)

--
Fable------------------------------------------------------------------------
Fable's Profile: www.excelforum.com/member.php...foamp;userid=2185
View this thread: www.excelforum.com/showthread...hreadid=503455Just 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)

quot;exsam21quot; gt; wrote in
message ...
gt;
gt; I want excel to count the # of days between 01/20/2006 and 02/28/2006
gt;
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile:
www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=503455
gt;