MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Calculation


Posted by Andrew on January 04, 2002 4:07 PM

Hello!

Is there anyone who might be familiar with calculating
the number of days based on a past given date and today's date.
Example: 12/15/01 - 01/04/02 = 20 days

Thanks!


Posted by Aladin Akyurek on January 04, 2002 4:10 PM

=TODAY()-A1

where A1 houses a paste date of interest like 12/15/01.

The cell of this formula must be formatted as General.

Aladin