help in writing a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
=TODAY()+15

you get the idea

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
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,
 
Back
Top