Forum Discussion
Excel Project due dates that fall on a monday, weekend or holiday roll back to previous friday
Hi!
You can use this formula:
[D2] : =C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16)
And drag it down.
I don't understand this part:
"... Also, I would like Holidays excluded"
What is your expected result? Blessings!
John,
Where may I buy your magic wand? The formula worked perfectly. Thank you, you Excel warrior!
Regarding ""... Also, I would like Holidays excluded"
What I meant: if the "Client Due Date" falls on a Holiday (on a Wednesday, for example), the "Internal Due Date" will roll back to the day before the holiday (in this example, Tuesday).
Thank you so much for your help. That formula was way over my head!
You're welcome!
For last comment, you can use this formula instead:
=C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16)-COUNTIF(C$11:C$20,C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16))
Blessings!
John,
This is perfect! Thank you for taking the time to help me!
John Jairo Vergara Domínguez wrote:
You're welcome!
For last comment, you can use this formula instead:
=C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16)-COUNTIF(C$11:C$20,C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16))
Blessings!
John Jairo Vergara Domínguez wrote:
You're welcome!
For last comment, you can use this formula instead:
=C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16)-COUNTIF(C$11:C$20,C2-(WEEKDAY(C2,12)>4)*WEEKDAY(C2,16))
Blessings!