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
 
Back
Top