software

Hi folks,
Apologies if my answer is here but I can't find it.
I have a task list and I need to record how many days since task
allocated.
So it's:
today - date allocated=135(days)
0r 03/03/2006-11/12/2005=82(days)

Many thanks in advance,

Scoville--
Scoville
------------------------------------------------------------------------
Scoville's Profile: www.excelforum.com/member.php...oamp;userid=32088
View this thread: www.excelforum.com/showthread...hreadid=518425If cell A1 is today and cell B1 is the date allocated, in cell C, which is
formatted as a number, type = A1-B1. If you need to include today, use
=A1-B1 1.

quot;Scovillequot; wrote:

gt;
gt; Hi folks,
gt; Apologies if my answer is here but I can't find it.
gt; I have a task list and I need to record how many days since task
gt; allocated.
gt; So it's:
gt; today - date allocated=135(days)
gt; 0r 03/03/2006-11/12/2005=82(days)
gt;
gt; Many thanks in advance,
gt;
gt; Scoville
gt;
gt;
gt; --
gt; Scoville
gt; ------------------------------------------------------------------------
gt; Scoville's Profile: www.excelforum.com/member.php...oamp;userid=32088
gt; View this thread: www.excelforum.com/showthread...hreadid=518425
gt;
gt;

=TODAY()-A1

where A1 is the date allocated

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Scovillequot; gt; wrote in
message ...
gt;
gt; Hi folks,
gt; Apologies if my answer is here but I can't find it.
gt; I have a task list and I need to record how many days since task
gt; allocated.
gt; So it's:
gt; today - date allocated=135(days)
gt; 0r 03/03/2006-11/12/2005=82(days)
gt;
gt; Many thanks in advance,
gt;
gt; Scoville
gt;
gt;
gt; --
gt; Scoville
gt; ------------------------------------------------------------------------
gt; Scoville's Profile:
www.excelforum.com/member.php...oamp;userid=32088
gt; View this thread: www.excelforum.com/showthread...hreadid=518425
gt;