Vlookup add days to dates considering no weekends/holidays

Hi!

I have a column that a user has entered a date something was submitted (Date Submitted to Courseware). Based on the priority selected (1-4), it will add a certain number of days to the Date Submitted to Courseware to tell me when it is due not counting weekends or holidays.

Formula:

=IFERROR(WORKDAY([Date Submitted to Courseware]@row, VLOOKUP([Analysis Priority]@row, AnalysisPriorityTypeDropDown47:AnalysisPriorityTypeValue51, 2), Holidays48:Holidays85), "")

Formula isn't working. Any suggestions?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

What exactly do you mean by "isn't working"? Are you getting an error?

Chelsea Duncan

No, no error. Nothing is showing.

Chelsea Duncan

And I've used the formulas given to me on my other posts but I'm still not getting it to work, calculate.

Chelsea Duncan

all fixed

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.