Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with automatic dates
Hello: I have craeted a spreadsheet with names and dates which have due dates for each name. My spreadsheet has the names in the first column; the type of follow up eg. 30 days, 60 days etc. and the last column has the date that the individual follow ups are due. How do I program Excel so that the due dates for each customer is automatically updated every 30 days, 60 days etc. Also, how do I link the cells with the dates to the individual columns. I hope that someone can help. Thanks. -- foxx60 ------------------------------------------------------------------------ foxx60's Profile: http://www.excelforum.com/member.php...o&userid=26427 View this thread: http://www.excelforum.com/showthread...hreadid=396942 |
#2
|
|||
|
|||
How do you calculate the due date? Do you have cell that contains the 'from when' date? -- hideki ------------------------------------------------------------------------ hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903 View this thread: http://www.excelforum.com/showthread...hreadid=396942 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I switch off automatic formatting (e.g. dates)? | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Automatic updating of Conditional Formats using dates | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |