Finding the Date X Business Days Back

An Excel file that teaches how to perform Finding the Date X Business Days Back operation.

Excel Spreadsheet for Finding the Date X Business Days Back

The date range is created using a formula. Holidays are excluded from the table. Working days are counted dynamically. The deadline is set automatically. Weekends are filtered out.

Hope it is useful.