Mallycat
YES! awesome
I used three columns one for 2005, one for 2006 and the last one for your
formula. Then hid the 2005 and the formula columns just leaving the 2006
column to update automatically. Thank you soooo much

"Mallycat" wrote:


Marilyn Wrote:

Please tell me there is a formula that will calculate the correct total

I can't think of an easy way. The COUNTIF function would be the
logical one to use but the criteria options are too limited. You could
do it in 2 steps though. Assuming you have a row or column of dates
where someone is absent, then create a formula that checks each cell to
see if it is in the last 12 months ie (assume C1 has the date of
absence)
=IF(TODAY()-C1<365,1,0)

copy the forumla for all absent dates, then sum the cells to see how
many absent they have had.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552860