Forum Discussion
Excel formula help
Hello, I am attempting to create a formula that will automatically calculate a set number of days from a specified date based upon the urgency of a call. For example: If I receive a “Priority 1...
Greetings,
Pls find formula
=SWITCH(PType,1,WORKDAY(B3,4,Hollist1),2,WORKDAY(B3,7,Hollist1),3,WORKDAY(B3,30,Hollist1))
Hope it helps.
Thanks
Pls find formula
=SWITCH(PType,1,WORKDAY(B3,4,Hollist1),2,WORKDAY(B3,7,Hollist1),3,WORKDAY(B3,30,Hollist1))
Hope it helps.
Thanks
With comment what for Priority 1 these are calendar days, not business one. Thus B3+4 or so, depends on receiving call date is included or not.
And perhaps values shall be "P1", "P2","P3" or so
Attached file for reference, the dates added to call dates as per specs provided and holidays excluding, (in the example file attached, Sat and Sun are taken as weekly off, including 1st Jan, other holidays can as well be included, thus arriving at business days (4,7,30) to be added to Initial call date.
I mean something like attached