Ah. I knew it had to be something with the TODAY statement in there but i didn't know it wasn't supported in the countif function, but it definatly makes sense sinc ei kept getting really wrong numbers returned. I had thought of something like what you suggested but was hopin to condense the count into one cell instead of useing hidden cells but i guess i can't get around it. Thanks for your help!