software

I need to calculate on a spreadsheet the number of days between a specific
date and the date the spread sheet is opened.
I need to know the number of days a merchandise has been stored.

=TODAY()-A1

where A1 holds that date, and format as general

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;South texas manquot; lt;South texas gt; wrote in
message ...
gt; I need to calculate on a spreadsheet the number of days between a specific
gt; date and the date the spread sheet is opened.
gt; I need to know the number of days a merchandise has been stored.
it did not work. B9 has the date it arrived at whse. I9 is the cell that I
need to have the number of days since merchandise arrived. Ex arrived on
05/10/06. the I9 should read quot;9quot;. With the formula =TODAY()-B9 it reads
quot;01/22/00quot;

quot;Bob Phillipsquot; wrote:

gt; =TODAY()-A1
gt;
gt; where A1 holds that date, and format as general
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;South texas manquot; lt;South texas gt; wrote in
gt; message ...
gt; gt; I need to calculate on a spreadsheet the number of days between a specific
gt; gt; date and the date the spread sheet is opened.
gt; gt; I need to know the number of days a merchandise has been stored.
gt;
gt;
gt;

Format that cell as general

--
Kevin Vaughnquot;South texas manquot; wrote:

gt; it did not work. B9 has the date it arrived at whse. I9 is the cell that I
gt; need to have the number of days since merchandise arrived. Ex arrived on
gt; 05/10/06. the I9 should read quot;9quot;. With the formula =TODAY()-B9 it reads
gt; quot;01/22/00quot;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =TODAY()-A1
gt; gt;
gt; gt; where A1 holds that date, and format as general
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;South texas manquot; lt;South texas gt; wrote in
gt; gt; message ...
gt; gt; gt; I need to calculate on a spreadsheet the number of days between a specific
gt; gt; gt; date and the date the spread sheet is opened.
gt; gt; gt; I need to know the number of days a merchandise has been stored.
gt; gt;
gt; gt;
gt; gt;

Sorry,
I don't know what I did wrong, it worked. THANKS!!!!

quot;South texas manquot; wrote:

gt; it did not work. B9 has the date it arrived at whse. I9 is the cell that I
gt; need to have the number of days since merchandise arrived. Ex arrived on
gt; 05/10/06. the I9 should read quot;9quot;. With the formula =TODAY()-B9 it reads
gt; quot;01/22/00quot;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =TODAY()-A1
gt; gt;
gt; gt; where A1 holds that date, and format as general
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;South texas manquot; lt;South texas gt; wrote in
gt; gt; message ...
gt; gt; gt; I need to calculate on a spreadsheet the number of days between a specific
gt; gt; gt; date and the date the spread sheet is opened.
gt; gt; gt; I need to know the number of days a merchandise has been stored.
gt; gt;
gt; gt;
gt; gt;