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