I track attendance for about 800 employees. If an individual reaches a total of 6 absences ( I have a sum column that adds up the absences) they are placed on a warning for attendance which lasts 3 months and they can not take what we call an emergency vacation day during those 3 months and then only in the next quarter (i.e. 3rd month is May, they can not take a emergency vacation until July 1, which is the start of the next quarter). Now here is where it gets even trickier if they miss 7 days they can not take that emergency vacation for 6 months and then the next quarter, 8 days they can not take that emergency vacation for 9 months and then the next quarter. This is all based on a rolling year meaning you could get 6 absences in November 2005 and then not be able to use an emergency vacation until April 1 of 2006 or worse yet build up a total of 9 absences in November which means the warning falls off in August 2006 but you can not take that emergency vacation until October 1 2006. On the attendance page I physically enter the drop off date of the warning and have conditioning formated the cell to turn green to let me know that the warning has fallen off, but I can not figure our how to link (based on the drop off date) on the vacation page when someone is eligible to use their emergency vacation day since they are different dates. If there is no ways I will have to resolve that I will have to add another column next to the warning drop off date, call it vacation date, condition format it and link it to the vacation page so I will know at a glance when they will be eligible for a emergency day. Sorry for being so long winded, I hope some of this makes sense.