Using workdays and adding holiday reference

Hi Community

I am trying to output only workdays so not Saturdays and Sundays.

On a second note I have a sheet called Holidays with specific holidays I need to exclude in the same formula, via reference another sheet. The holiday sheet is called Holidays and the column where it is located is column 8

But how can I do this easily, something like ....<> ""; WORKDAY...?

This is the formula from the date column

Thanks 😊

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You are going to end up with something like this...

=WORKDAY([Start Date]@row, ##, {Other Sheet Holidays Column})

Lasse Dupont

Hi Paul,

and thanks

Sorry i did not add the original formula

=IF([SLA Model]@row = "Normal (6 Days)"; ([Send-out date]@row - 6) + " - " + [Send-out time (GMT)]@row; IF([SLA Model]@row = "Fast Track (4 Days)"; [Send-out date]@row - 4; IF([SLA Model]10 = "Emergency (2 Days)"; [Send-out date]@row - 2) + " - " + [Send-out time (GMT)]@row))

Paul Newcome

Where are you trying to incorporate your holidays?

Lasse Dupont

after [Send-out date]@row - 4 -{[Holidays]}

It's fetched from another sheet called holidays via Smartsheet function "Reference another sheet" -> Holidays -> Column 8

Paul Newcome

Try this...

=WORKDAY([Send Out Date]@row; IF([SLA Model]@row = "Normal (6 Days)"; - 6; IF([SLA Model]@row = "Fast Track (4 Days)"; -4; IF([SLA Model]10 = "Emergency (2 Days)"; -2))); {Other Sheet Holiday Range}) + " - " + [Send-out time (GMT)]@row

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.