Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-11-2011, 03:09 AM
tinfanide tinfanide is offline Date Subtraction Windows XP Date Subtraction Office 2010 32bit
Expert
Date Subtraction
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formatting kjxavier Excel 0 08-10-2011 08:17 AM
Date Subtraction Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM
Date Subtraction 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
Date Subtraction Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft