Employee Calendar Calculation Problem

[jasono]

Have a question hoping to get some help with. Need someone smarter than me to figure this out.

I'm creating an attendance calendar for my employees where they can go in to view their amount of vacation days and other bonus days they are given.

I've got it figured out except for what we call and "Earned Day". An employee earns an Earned Day for 3 months of perfect attendance.

On my calendar for each month there is a row called "Marks". Here, as long as the employee does not have an L (Late), LE (Leave Early), NCNS (No Call No Show) within the 3 months he is eligible to get the Earned Day, which is noted as ED* in the Earned column.

For example, on the calendar I have attached, there is an ED* on cell S35 (which corresponds to date March 17th).

The code should look for the last ED* on the spreadsheet, and write ED* to cell S65 (which corresponds to June 17th) as long as there are no (L,LE,NCNS) between that time frame.

If there is an (L,LE,NCNS) in the columns, write ED* in the row which corresponds to 3 months after the date of the L,LE, NCNS).

I appreciate the help of anyone who attempts to tackle this one.