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
|