ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Need to create formula based on date (https://www.excelbanter.com/new-users-excel/120894-need-create-formula-based-date.html)

Eileen

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.


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com