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...
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!