Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Expiring
Please look at my example first of all here, then read my question:
http://img378.imageshack.us/img378/5...ochange4tt.jpg If we entered an item like '1', and after a year, it expires and goes back to '0', is there a way to automatically do this in Excel, so I don't have to go through and change it to 0 manually after a year for each day? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to alert if expiring within 40 days | Excel Worksheet Functions |