Try:

=IF(TODAY()<DATE(YEAR(D7)+1,MONTH(D7),DAY(D7)),1,0 )

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Travis King" wrote in message
news:AREgg.17245$No1.15164@attbi_s71...
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.