list text from a cell if condition met

[DD]

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 text( unexcused absence, unexcused tardy etc)

1/16/06
TPU 8
Occ
Unexcused Absence (Whole)



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 otherwise will skip the
date. 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 days from 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

 

[ShaneDevenshire]

Could you diagram for us a sample of the original data. I believe that the
solution will probably involve using the Data, Filter, Advanced filter
command but I will be better able to tell you when you show some sample data.

 

[mk]

Could you diagram for us a sample of the original data. I believe that the
solution will probably involve using the Data, Filter, Advanced filter
command but I will be better able to tell you when you show some sample data.

Here it is. One day square and first week of January. Teh cells
starts at A10 and ends at Aw268


1/03/06
TPU 8
Occ
Unexcused Absence (Whole)


January
SUN MON TUE WED THU FRI SAT
1 2 01/03/06 4 5 6
HOL 8 TPU 8
Occ
Unexcused Absence (Whole)
The result should look something like this:

Unexcused..(whole) Unexcused ...(Half)
Unexcused Tardi

01/03/06(if <365 days from
todays date)
02/15/06
03/25/06
01/15/07

Thanks