I am needing to add two weeks on to date in a separate column.
In one column (
A) I have the "Date Requested" and in the next column (
B) I have "Due Date" I need the due date column to have the "Date Requested + 2 weeks" (only weekdays). I know the formula to just put it in the cell, but I am having trouble putting it into the Data Validation option so that I do not have to keep copying the formula every time I insert a new row.