View Single Post
  #1   Report Post  
ILanger
 
Posts: n/a
Default How do I add on 15 days to a specified date

Column D of my spreadsheet has the dates that I begin various tasks
I would like Column E to automatically fix a date 15 days later to be my
Target Completion Date Goal.
Then I would like Column F to tell me how many days left until the Target
Date in Column E
The dates in Columns D & E would not change; but the Days Left in Column F
would change each day.
Please tell me what formulas I should put into Columns E & F

Many thanks in advance.