Now here's the problem that might make this more difficult, I was using the
1 and the 0 as a sample. My dad wants to keep track of the amount of days
he has used FMLA. After a year, it expires or is removed and is no longer
counted. That's why I needed to know. The problem is, when I use 'FMLA',
it doesn't seem to want to accept it. I've adjusted the formula by plugging
in 'FMLA' instead of 1. It will not accept the formulas now. It was
working the way that Sandy told me to try when I was using numbers. The 0
stood for the days he didn't use FMLA and the 1 stood for the days that he
did use FMLA. I wanted to replace the 1 with the word, 'FMLA' instead so it
was easy to tell what it meant. Then, he also wanted to know how many
FMLA's he used. I used the 'countif' formula for that, and this worked, but
using this formula doesn't when it comes to expiring. I will still use 0
for days he hasn't used FMLA, but I want to use the word 'FMLA' for days he
has. How would the formula work now? Sandy's method was the way that
worked correctly. The other methods kind of worked, but didn't work the way
I wanted them to. Thanks again to the both of you.
"kkchoh" <kkchohATyahoo.com wrote in message
...
Try

=IF(Year(Today())=Year(D7),1,0)

Or

=--(Year(Today())=Year(D7))


"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.