Forum Discussion
Using WORKDAY to create a list of projected job start dates.
"Days" = project workdays "Start Date" = expected project start date "Sheet2!A2:A7" = a table of holidays I wanted to copy the formula down the column, but it won't keep the reference to the holid...
Try Sheet2!$A$:$A$7
In excel the $ acts and an anchor an prevents the behavior you are seeing.
Your could also use a named range, details here:
With that you could replace name you holidays 'holidays' and just refer to it that way in your formula.