Date subtraction

If I want to subtract "days" from two cells that have dates formatted such as 09/03/13, and 11/03/13, how do I write a successful formula in a empty cell to facilitate this request?
Pete EdwardsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
barry houdiniConnect With a Mentor Commented:
OK, sorry so you want the number of days from your dates until a specific date?

If you have dates in A2 down then put this formula in B2

=DATE(2013,10,31)-A2

format B2 as general and then you can drag the formula down the column - it will automatically adjust for all your other dates

regards, barry
0
 
barry houdiniCommented:
Days are simply integers in Excel so if you have a date in A1 you can get 10 days before that date by subtracting 10, i. e in B1

=A1-10

format B1 inthe same date format

regards, barry
0
 
Pete EdwardsAuthor Commented:
i have a broad range of dates going back 5 years formatted as mentioned above all accross the board I want to subtract by 10/31/13 to see how many days, how do I do this Barry in an empty cell?

Thanks
0
 
Pete EdwardsAuthor Commented:
Thanks Barry.
0
All Courses

From novice to tech pro — start learning today.