• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

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?
0
Pete Edwards
Asked:
Pete Edwards
  • 2
  • 2
1 Solution
 
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
 
barry houdiniCommented:
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
 
Pete EdwardsAuthor Commented:
Thanks Barry.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now