help in writing a formula
 

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

help in writing a formula
 

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

"Soth" wrote in message
...
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

help in writing a formula
 

=TODAY()+15

you get the idea

--
---
HTH

Bob

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



"Soth" wrote in message
...
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

help in writing a formula
 

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

"Soth" wrote:

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

help in writing a formula
 

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,
--
*****
birds of the same feather flock together..



"Soth" wrote:

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