Variable Holidays in Networkdays function

RSquirrel · Nov 4th 2022

The Holidays argument in Excel's Networkdays function is simple for those holidays with fixed dates (e.g. 12-24, 7-4, etc.) but how can those holidays whose dates are not fixed (e.g. Easter, Labor Day, etc.) be accounted for (I assume with some dedicated VBA code, as opposed to a formula)?

Pecoflyer · Nov 9th 2022

You can enter a range in the Holidays argument containing formulas that calculate variable holidays

I found one for Easter at https://www.contextures.com/exceleastercalculation.html

As for Labor day, it depends on the country I suppose. So, search the Net for other variable dates you need, there is probably an answer out there

Variable Holidays in Networkdays function

Participate now!

Share

Similar Threads

Using SUBTOTAL formula within an IF formula

Finding a match in strings in 2 columns n 2 sheets and if match found copy cell to sheet 1

VBA Copy rows to another sheet due to cell value from dropdown list

Compile Error: Invalid Use Of Me Keyword

Missing Something Simple Retrieving Value in Active Cell and Assigning it to a Variable in VBA - Please Help