MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Calculation

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


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


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


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

The cell of this formula must be formatted as General.