How to find Target Date with Condition below

1.if today find yesterday

2.if yesterday equal weekday

3.if yesterday equal weekday+Holiday

4.difference of today and Target Date

1.if today find yesterday

2.if yesterday equal weekday

3.if yesterday equal weekday+Holiday

4.difference of today and Target Date