Share via

Using WORKDAY Function in Multiple Column Cells

Anonymous
2017-11-19T16:42:08+00:00

I have many rows needing the WORKDAY function to determine due date as a business day. I have the holiday data in one set of fields. How do I get the holiday fields referenced to remain the same in every field as I copy the formula down throughout the column?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2017-11-19T18:20:48+00:00

Use absolute referencing. For example, if the holidays are specified on Sheet2 in A2:A50, use a formula such as

=WORKDAY(D1, 180, Sheet2!$A$2:$A$50)

where D1 contains a starting date and 180 is the duration in days. This formula can be filled down. The $ iin $A$2:$A$50 ensure that this reference won't change.

Even easier: select the range with holiday dates (A2:A50 on Sheet2 in our example). Then click in the address box on the left hand side of the formula bar, type the name Holidays and press Enter. You can now refer to the range by its name:

=WORKDAY(D1, 180, Holidays)

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest