As stated in the title, I'm using the Workday function in Excel 2010.
I'm using two worksheets. Sheet1 contain the cells I would like populated and sheet2 I have an array containing a list of holidays observed (Sheet2!B3:B11) . I have a list of dates in Column A. Cell A3 contains the first date of Friday, January 05, 2018. In Cell A4 contains the formula of "=WORKDAY(A3,1,Sheet2!B3:B11)".
The problem that I am having is that when I copy and paste this formula down column A it increments the cell number of Sheet2!B3:B11 (This should be a fixed). So when I copy and paste this formula into cell A4 the cell values of the formula gets incremented as well to " =WORKDAY(A4,1,Sheet2!B4:B12)" and when I copy it to cell A5 "=WORKDAY(A5,1,Sheet2!B5:B13)" and so on. The date value increment correctly. How can I fix this without manually correcting each cell. The date range starts at
Friday, January 05, 2018, as stated previously, and ends at
Monday, December 31, 2018. Thank you.