CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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"
 
Format that cell as general

--
Kevin Vaughn


South texas man said:
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"
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need help with a Function 0
Has @DAYS 360 function calculated differently between qtr and mon 1
Calculating number of workdays between 2 dates 14
Calculating total number of days 3
Number of Weekend Days between 2 Dates Q 1
How to calculate # of days 3
Excel Message box with days of month & date. 1
Counting days from a date 3

Back
Top