•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to calculate a due date in business days
I need a formula to calculate a business day due date based off the received date and request type.
Currently I have this setup calculating calendar days:
Column E: Received Date
Column G: Request Type; It is a drop-down where the user can pick either Expedited or Standard.
Column H: Allotted number of days; Current formula: =IFS(G2="Expedited", 3, G2="Standard", 5)
Column I: Due Date; Current formula: H2+E2
I need Column I to show the result of Column E + 5 *business* days instead of calendar days (when Standard is selected in column G). Expedite should be 1 calendar day. How would I go about doing that?
Using Excel for 365 version 2512 64 bit
[link] [comments]
Want to read more?
Check out the full article on the original site