Can someone please show me a function that can produce the following.
I have 6 dates (2/06,3/09,4/07,3/06,7/06,1/06) where the format of the
date is "d/mm" (day/month). these dates are in cells A1:F1.
now below the dates in cells A2,D2,E2,and F2 is the word "Absent"

I need a formula that will give me only the days that are in the month
of june, and then count how many "Absences" are assocated with each day
in june.

I hope that this makes sense..

ssrvant


--
ssrvant
------------------------------------------------------------------------
ssrvant's Profile: http://www.excelforum.com/member.php...o&userid=35729
View this thread: http://www.excelforum.com/showthread...hreadid=555158