Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need to create formula based on date
in B1:
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) In C1: =IF(B1TODAY(),"ok","past due") -- Gary's Student "eileen" wrote: 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 | |||
formula for lenght of employment based on hire date | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | 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 |