Vlookup add days to dates considering no weekends/holidays

Chelsea Duncan

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?

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