Forum Discussion
Backdating tasks excluding weekends.
I need to figure out how to backdate multiple tasks in excel, by inputting a final date. This also needs to exclude weekends? Please may someone help and point me in the right direction. This...
Let's say the end date (25 December 2024) is in C12.
I'll assume that you have created a list of public holidays and named it Holidays.
In C11:
=WORKDAY.INTL($C$12, -B11, , Holidays)
Fill or copy upwards.