Can someone help correct this formula

Carol Suhar

I have been trying to calculate a due date based on the date an issue was received and the priority.I have entered the following:

=WORKDAY(IF([Priority]10, "red", [Date Received]10, 0), IF([Priority]10, "Yellow", [Date Received]10, 2), IF([Priority]10, "Green", [Date Received]10, 4), IF([Priority]10, "blue", [Date Received]10, 14))

and I get "incorrect data set" as my message. Any ideas?

Paul Newcome

It looks like you want to change how many days are added based on the priority, but you are keeping the same start date.

=WORKDAY([Date Received]@row, number of days to add)

The number of days to add is where you want your nested IF statement.

=IF(Priority@row = "Red", 0, IF(Priority@row = "Yellow", 2, IF(Priority@row = "Green", 14)))

So now that we have our IF working to generate the numbers of days to add, we can drop it into our WORKDAY function:

=WORKDAY([Date Received]@row, IF(Priority@row = "Red", 0, IF(Priority@row = "Yellow", 2, IF(Priority@row = "Green", 14))))