Thread: Expiring
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Travis King
 
Posts: n/a
Default 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.