Excel - From a date to find the number of days ago that date was.

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Can anyone tell me how to convert a date to the number of
days ago that date actually was? I need to find the number
of days ago. Thanks in advance!
 
Michael
the function Today() returns you a number when the cell is
formatted 'General' or 'Number' -today sept 29 you get
37893-. Apply the same to your date and deduct one from
the other
Generally speaking, why don't you read 'About dates and
date systems' in Excel Help
Emm
 

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

Convert Number of Month to Number of days 4
New Version Windows 10 13
Access Dateadd function question.. 0
Defaulting to date format 4
XL2007: Pivot table date filter 1
Calculate a date 5
Spreading date range across days in weeks (advanced) 7
Number of the day of the year 3

Back
Top