| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need to create formula based on date
If I enter the date of 9/30/03 in cell A1, I want the renewal date in five
years from this date (9/30/08) to populate in cell B1. Then in cell C1 I want the words to say either "ok" or "past due" based upon whether the customer is past the renewal date or not. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| formula for lenght of employment based on hire date | Excel Worksheet Functions | |||
| Update a formula based on date worksheet was saved | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
