holiday date formula

  1. C

    Round to Thursday if first Friday formula returns a holiday

    Hello, I have a formula that returns the first Friday of the month based on the date entered into another cell. I can't figure out how to have the date "round" to the Thursday before if the 1st Friday is a holiday. The formula for the 1st Friday calculation is: =IF(A2=0,"...
    • cjtleno
    • Thread
    • exclude holidays first friday of month holiday date formula
    • Replies: 5
    • Forum: Excel Questions
  2. R

    Exclude holidays but include weekends

    Hi All, I need to create a formula that removes holidays from the equation, but does not exclude weekends. All of the workday.intl options want to remove at least 1 day a week for the weekend. I need a formula that would tell me what 40 days is before a certain date, but need an extra day in...
  3. SelinaR

    Using WORKDAYS formula with "Holiday" range - not calculating correctly

    Hiya I have read through the forums, but can't seem to find an answer to my unique situation.... Action: I need to calculate 5 working days after a date and include holidays Formula: Using workdays formula and named my holiday range pubhol18 (I have also tried just selecting the range)...
    • SelinaR
    • Thread
    • formula holiday holiday date formula range workdays
    • Replies: 7
    • Forum: Excel Questions
  4. A

    Holiday Next Business Day formula fix

    In need of a fix/adjustment to the following formula so if a date falls on a holiday(whether a one day or two day holiday) it changes the date to the next business day with a 08:00 or 09:00 time (EST or EDT dependent). I use a lookup table to list holidays (date only). Current formula is for...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top