IF formula to return date based on drop down selection

katie.mcelroy

I have a formula that is working correctly returning a date based on a drop down selection. Now I need to incorporate business days into that return date instead of total day.

I have 3 columns i'm working with, Priority, Requested date and Request due. The user will enter the date the request is received and select the priority. If P1 the due date will populate 2 weeks from the request date, P2 3 weeks and so on. I have the below formula setup and it's working great. Now I need to only calculate business days. How do I incorporate NETWORKDAYS into this formula? Every way I try returns errors.

=IF([PRF Priority]@row = "P1", [Date Sales Proposal Request Received]@row + 14, IF([PRF Priority]@row = "P2", [Date Sales Proposal Request Received]@row + 21, IF([PRF Priority]@row = "P3", [Date Sales Proposal Request Received]@row + 28, IF([PRF Priority]@row = "P4", [Date Sales Proposal Request Received]@row + 42))))

Nic Larsen

Try:

=IF([PRF Priority]@row = "P1", WORKDAY([Date Sales Proposal Request Received]@row, 14), IF([PRF Priority]@row = "P2", WORKDAY([Date Sales Proposal Request Received]@row, 21), IF([PRF Priority]@row = "P3", WORKDAY([Date Sales Proposal Request Received]@row, 28), IF([PRF Priority]@row = "P4", WORKDAY([Date Sales Proposal Request Received]@row, 42), "")