Hello,

I have a formula in Excel that when the date in a field is a Monday it returns that same Monday, same thing for Tuesday. When it is a Wednesday it returns the previous Tuesday, etc.

=IF(WEEKDAY(E2)=2,E2,IF(WEEKDAY(E2)=3,E2,IF(WEEKDAY(E2)=4,E2-1,IF(WEEKDAY(E2)=5,E2+4,IF(WEEKDAY(E2)=6,E2+3)))))

But I would like to enter a Holiday calendar and if the result falls on one of the Holidays, I would specify in that same calendar which day I want it to be instead.

How could I add this to my existing formula?


Patricia