Hello! I'm responsible for ensuring a large number of reports are submitted on time. To meet deadline, I'd like to adjust the due date to account for holidays and weekends.
I added all holiday dates to a separate "Holidays" column, and identified day of the week in a separate "Due Date Day" column using the formula =IF([Due Date]@row = "", "", WEEKDAY([Due Date]@row)).
My current attempt has two nested IF formulas. The first identifies if the date is in the Holiday column AND is a Sunday OR Monday, it will add a day to the due date. The second identifies if the date is in the Holiday column AND is a Friday OR Saturday, it will subtract a day from the due date.
=IF(AND(VLOOKUP([Due Date]@row, Holidays:Holidays, 1, false), <>"#NO MATCH", OR([Due Date Day]@row = "1", [Due Date Day]@row = "2")), [Due Date]@row + 1, "", IF(AND(VLOOKUP([Due Date]@row, Holidays:Holidays, 1, false), <>"#NO MATCH", OR([Due Date Day]@row = "6", [Due Date Day]@row = "7")), [Due Date]@row - 1, ""))
However, I'm receiving the error "#INCORRECT ARGUMENT SET"
Can you see where my formula needs to be adjusted?
Thanks for your help!!
