Observed Holidays UDF

[brncao]

There's a guide for how to create a table with holidays in them, and the only input the users need is Year, which the functions will determine what the holiday date is. However, I want to do away with the table and go with a UDF approach. The only argument that is required would be the year.

I would like the UDF to take the year argument, and produce an array of "Observed" holidays; the function will return an array of dates.

It will be used in this WORKDAY function:

=WORKDAY(B1,1,OBSHOLIDAYS(year))

Is there something like this out there?

 

[DRSteele]

There is a new function in up-to-date Excel: NETWORKDAYS.INTL

You can investigate its use and determine whether or not it meets your needs. https://support.office.com/en-us/ar...pId=xlmain11.chm60568&ui=en-US&rs=en-US&ad=US

 

[mikerickson]

Which holidays are observed varies from country to country and even within a country.

You could write you own UDF something like

Function ObsHolidays(year as Long) As Variant
    Dim Result(1 to 12) As Date

    Result(1) = DateValue("1/1/" & Year)
    Result(2) = DateValue("1/16/" & Year)
    '...
    Result(12) = DateValue("12/25/" & Year)

    ObsHolidays = Result
End Function