ILanger, with date in D2, in E2 put =D2+15 in F2 put =E2-TODAY() and format
as general
--
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
"ILanger" wrote in message
...
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.
|