How do you create a sheet that calculates 60 weekdays minus holidays?

Hello,

I am trying to create a sheet that calculates 60 school days from a specific date. It needs to omit weekends, holidays and breaks. I used the following formula and it is still not calculating correctly.

=WORKDAY([Document Date Signed]@ros, 60, [PPS Holidays]@row)

I entered all of the holidays in the holiday column but it is still multiple days off. I also tried entering the weekends in the holiday column but it is still not calculating correctly. I don't have dependencies turned on because that requires a start and end date column.

Find more posts tagged with

Education

Formulas

Accepted answers

All comments

Kerry St. Thomas

What I'm seeing as a possible inconsistency is the final clause. As I understand, it should be a range and not an individual row reference. So I'd expect to see [PPS Holidays]:[PPS Holidays] - or {Holidays} if it's a cross-sheet reference. If that's not it, can you include a screenshot to show how your sheet/s are set up? Thanks!

gjohnso1

Thank you. I have not been able to get it to work but I am really new to using Smartsheet's so it is probably something I am doing incorrectly.

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, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.