i found this formula to tell me what day Thanksgiving is depending on year
=DATE(Z8,11,1)+IF(5<WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)
What i need is to modify it so i can find the Friday afer thanksgiving
=DATE(Z8,11,1)+IF(5<WEEKDAY(DATE(Z8,11,1)),7-WEEKDAY(DATE(Z8,11,1))+5,5-WEEKDAY(DATE(Z8,11,1)))+((4-1)*7)
What i need is to modify it so i can find the Friday afer thanksgiving