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?
|