View Single Post
 
Old 08-11-2011, 03:09 AM
tinfanide tinfanide is offline Windows XP Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default 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?
Reply With Quote