|
|
#1
08-11-2011, 03:09 AM
|
|||
|
|||
Date Subtraction
A1 = formula
A2:(infinite) Date I want starting from A2 when I type in a date, the newest substrates the oldest. When a date is added, it becomes the newest date. I know A3-A2 can return the sum of days but in this case it involves the use of table in 2010. If I do the subtraction, when I add a new date at the bottom of the table, the date is not counted. Is there any way to make it done? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Date formatting | kjxavier | Excel | 0 | 08-10-2011 08:17 AM |
 Need a date formula
|
MPAVLAS | Excel | 3 | 08-12-2010 10:04 PM |
|
Julian Date
|
windseaker | Excel | 1 | 02-14-2010 01:44 AM |
| new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
|
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |
Windows XP 
Office 2010 32bit
Threaded Mode