Lieu day off for a holiday on weekend

How can a lieu/alternate date for Stat holidays that fall on a weekend be calculated? For example, in 2023, January 1st falls on Sunday and Nov 11th falls on Saturday. If a holiday is on Sunday, it needs to add 1 day and if it's on a Saturday, it needs to add 2 days. Here's my two novice unsuccessful attempts at this formula where D14 is the stat holiday date:

=IF(WEEKDAY($D14,2)=7,$D14+1)=IF(WEEKDAY($D14,2)=6,$D14+2)
This returns True if it's a weekday and False if it's a weekend but I want it to return the new date if it's on a weekEND and the same date if it's on a weekDAY.

=IF(WEEKDAY($D14,2)>5),WORKDAY($D14,2)
This alternative option is not working at all.

Thanks in advance for your help.

Try:

Formula:

Please Login or Register  to view this content.

Good luck!

That worked! Thank YOU so much!

You're welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!

Thanks for replying Bebo. However, that solution only works if the holiday falls on a weekend. If the holiday falls on a weekday, it results in a wrong future date.
In my above alternate option, I was trying to use next workday if the holiday date was on a weekend, but the formula I wrote was not functional.

The alternate formula that also works now is:
=IF(WEEKDAY($D14,2)>5,WORKDAY($D14,1),$D14)
Thank you so much for helping out a nurse that's trying to create a customized team vacation calendar. So generous of you to share your expertise.