I have a excel sheet with a date column and data columns for work a, b, c, and d
My goal is to update data only on working days
I use a date sheet and the WORKDAY.INTL and SEQUENCE formulas to exclude weekends and holidays (holidays can be manually updated in the holidays column)
After removing weekends and holidays, I generate a date list in the CPP sheet. When I update new holidays in the holidays column, the new holiday dates are removed from the date list in the CPP sheet, but the Work A, B, C, and D data do not update.
How can I make the date list change and Work A, B, C, and D data update automatically?
My goal is to update data only on working days
I use a date sheet and the WORKDAY.INTL and SEQUENCE formulas to exclude weekends and holidays (holidays can be manually updated in the holidays column)
After removing weekends and holidays, I generate a date list in the CPP sheet. When I update new holidays in the holidays column, the new holiday dates are removed from the date list in the CPP sheet, but the Work A, B, C, and D data do not update.
How can I make the date list change and Work A, B, C, and D data update automatically?