here is the code


Code:
--------------------
=IF(YEAR(TODAY())=$A$3,IF(MONTH(TODAY())=$B11,COUN TA($A$35:$A$59),0),$C10)
--------------------


a3=year
b11=month in number format
a35:a59=list of names

it can depend on month and year this function.


--
jay d
------------------------------------------------------------------------
jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487
View this thread: http://www.excelforum.com/showthread...hreadid=542487