Remember Me?

#1
May 19th 06, 12:33 AM posted to microsoft.public.excel.worksheet.functions
 South texas man Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

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.

#2
May 19th 06, 12:41 AM posted to microsoft.public.excel.worksheet.functions
 Bob Phillips Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

=TODAY()-A1

where A1 holds that date, and format as general

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

#3
May 19th 06, 03:59 PM posted to microsoft.public.excel.worksheet.functions
 South texas man Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

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 "9". With the formula =TODAY()-B9 it reads
"01/22/00"

"Bob Phillips" wrote:

=TODAY()-A1

where A1 holds that date, and format as general

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

#4
May 19th 06, 08:01 PM posted to microsoft.public.excel.worksheet.functions
 Kevin Vaughn Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

Format that cell as general

--
Kevin Vaughn

"South texas man" wrote:

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 "9". With the formula =TODAY()-B9 it reads
"01/22/00"

"Bob Phillips" wrote:

=TODAY()-A1

where A1 holds that date, and format as general

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

#5
May 19th 06, 08:37 PM posted to microsoft.public.excel.worksheet.functions
 South texas man Posts: n/a
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

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

"South texas man" wrote:

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 "9". With the formula =TODAY()-B9 it reads
"01/22/00"

"Bob Phillips" wrote:

=TODAY()-A1

where A1 holds that date, and format as general

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post John DeLosa Excel Discussion (Misc queries) 4 February 16th 06 09:30 PM kathi Excel Worksheet Functions 1 February 14th 06 04:11 PM shaunl Excel Discussion (Misc queries) 5 July 13th 05 02:38 PM zooming Excel Worksheet Functions 2 June 21st 05 04:01 PM Rich New Users to Excel 2 December 9th 04 02:06 AM

All times are GMT +1. The time now is 07:50 AM.