Forum Discussion
Excel Project due dates that fall on a monday, weekend or holiday roll back to previous friday
I am creating project task matrix in excel. All "Client Due Dates" are based on the starting date (Project Task 1"). If a "Client Due Date" is due on a monday or weekend, the "Internal Due Date" shou...
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!