•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
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#business intelligence tools
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#cloud-based spreadsheet applications
#due date
#business days
#formula
#calendar days
#received date
#request type
#Expedited
#Standard
#allotted number of days
#column E