What happens if the Holiday is on Saturday?



"Steve" wrote in message
...

If I have holidays identified with an H in the A column, I need to find
the
prior Tues, from the Sat prior to the holiday.
Basically I need to find the Sat prior to the holiday, then go back 4
days.
I'd like the results to show in the D column like ALERT.

Thanks,

Steve

A B C D
6/28/10 Mon
6/29/10 Tue ALERT
6/30/10 Wed
7/1/10 Thu
7/2/10 Fri
7/3/10 Sat
H 7/4/10 Sun
7/5/10 Mon
7/6/10 Tue
7/7/10 Wed
7/8/10 Thu
7/9/10 Fri