list text from a cell if condition met
 

Hi, I need help.

I have attendance calendar for each date it has four raws.
the first raw has date
second raw has input fields
third raw has formulas and returns value based on raw 2 and raw 4
raw four has different test( unexcused absence, unexcused tardy etc)

What i need to do is create a formula that will look through 2006
calendar, check the date if is <365 days from the curent date and the 4
raw has "unexcused absence" or "unexcused Tardy", it will list the
date for every time the above conditions meets. So the result will look
like

Unexcused absence Unexcused Tardy
1/20/2006
1/23/2006
5/20/2006

Thu sI will have a list of all dates that have the each category in the
fourth raw and the date in the first raw is <365 day sfrom today. In
additions as date changes the list will drop the date as it will be
365 days from the current date.

I hope this make sense.

Thanks