View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default 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