Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |