Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Your answer worked perfectly. Thank you for your very prompt help. Is there a beginners tutorial that will teach me how to use the various date formulas? I guess I have to start somewhere. Thanks again. "Paul B" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
subtracting 30 days from any date. | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |