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 is what I have got setup so far.
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.
This lacks the holidays and internationalisation of weekends that HansVogelaar catered for but it is structured to return results as a dynamic array.
= WORKDAY(targetDate, -daysRequired)[the main difference is that I always use array formulas and reference all data by name]
