calculate calender dates

[sophie6]

In my excel I want to use a calender date such as 05/21/09 and automatically add or subtract a specific number of days.

For example:

10 days before 05/21/09....

I dont want to have to count back 10 days and manually enter it.

Is there a way to have excel calculate and give me the date in my spreadsheet?

i.e. automatically calculate (05/12/09)-(10 days)= 5/11/09

its not too hard when its 10 days, but when its -97 days, it can be very annoying.

thanks in advance

[teylyn]

Hi Sophie6,

welcome to the forum.

With a date in cell A1 and a number (of days) in B1, you can use

=A1-B1

to arrive at the result. Format the result as a date.

but this:

.e. automatically calculate (05/12/09)-(10 days)= 5/11/09

does not make sense. It would help if you could specify the date format you're using, i.e is that May-12 or Dec-5?

if May, then the result should be 05/02/09
if Dec, then the result should be 25/11/09

but in neither case 5/11/09 !!

[Jbentley]

Hi,
In Excel Dates are treated as numbers for calculations.

Try this:

In a blank sheet enter any date you want in cell B2.
In cell C2 enter the number of days you want to deduct ( eg. 97 )
In cell D2 enter the following:

Please Login or Register  to view this content.

Format cell D2 as Date.


Hope that helps

[sophie6]

I have a date that I enter in A1 (which is a due date)... for examples sake lets say its 5/21/09...

And lets say I want to send out a reminder to someone X days before that date I entered.

So say I want to send out a letter 10 days earlier than the due date.

I would want to be able to take cell A1, and automatically have it produce a date +/- whatever number I pick...

hope that makes sense, thanks for the welcome, and thanks for your help!

[sophie6]

Thank you....this helped. Only thing I'd add now is that instead of doing B2-C2, you can put B2+C2. Then if you want to go back 10 days you do -10, and if you want to know 10 days later, you do 10

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save