help in writing a formula

S

Soth

Hi,

I'd like to accomplish a date formula.
For example,
- Today's date 02/01/2007
- Due date 02/16/2007

I'd like to have 15 days due date from today's date. How do accomplish this
formula? or it could be 10 days...

Thanks
Soth
 
P

Paul B

Soth, with today's date in A1, =A1+15

Or with it in the formula =TODAY()+15

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

Bob Phillips

=TODAY()+15

you get the idea

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

john the confused

Try putting in the following

Cell A1 =TODAY()
Cell A2 the number of days you want to add (say 15)
Cell A3 =A1+A2. This will give you the date after you have added the number
of days in cell A2 from todays date.

John
 
D

driller

try to fix your start date AND due date
A1=02/01/2007
A2=15
A3=A1+A2
result is 02/16/2007

if u try to use an A1=today()
you can see that the A3 result for tomorrow will move to 02/17/2007.
a moving DUE date.


regards,
 
Top