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.
--
Thanks,
Shane Devenshire


"DD" wrote:

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