View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
john the confused john the confused is offline
external usenet poster
 
Posts: 51
Default 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