Question description:
This user has given permission to use the problem statement for this
blog.
Column A "Date Received"
Column C "Priority" is validation list with options P1-P6
Column D "Due Date"
.. How do I make Column D calculate the due date, based on which option is selected in Column C in conjunction with the date in Column A?
PI = Date Received
P2 = Date Received
P3 = Date Received + 1 day
P4 = Date Received + 5 business days
P5 = Date Received + 14 business days
P6 = Date Received + 30 business days
Solved by D. U. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
17/09/2018 - 01:19
Hi
Excelchat Expert
17/09/2018 - 01:19
Welcome to Excelchat, I see that your question is about to fixing the formulas
Excelchat Expert
17/09/2018 - 01:20
Can you please share your excel sheet
Excelchat Expert
17/09/2018 - 01:20
Are you there with me?
User
17/09/2018 - 01:21
Hi
Excelchat Expert
17/09/2018 - 01:21
Do you have any excel sheet?
User
17/09/2018 - 01:21
Just about to share my spreadsheet
Excelchat Expert
17/09/2018 - 01:21
Ok...
Excelchat Expert
17/09/2018 - 01:21
Waiting for your excel sheet
User
17/09/2018 - 01:21
It is in very very eary stages sorry
Excelchat Expert
17/09/2018 - 01:21
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows
Excelchat Expert
17/09/2018 - 01:22
Shall I create my own?
User
17/09/2018 - 01:22
I shared the sheet
[Uploaded an Excel file]
Excelchat Expert
17/09/2018 - 01:22
Thank you
Excelchat Expert
17/09/2018 - 01:22
Let me check one minute
Excelchat Expert
17/09/2018 - 01:23
I got your excel sheet
Excelchat Expert
17/09/2018 - 01:24
P1 to P3 = Received date+1
Excelchat Expert
17/09/2018 - 01:24
P4 = Date received +5
Excelchat Expert
17/09/2018 - 01:24
P5 = Date received+14
User
17/09/2018 - 01:24
P1 - P2 = Date Received
Excelchat Expert
17/09/2018 - 01:24
P6 = Date received +30
Excelchat Expert
17/09/2018 - 01:25
Sorry I didnt get you
Excelchat Expert
17/09/2018 - 01:25
Oh ok. same day
User
17/09/2018 - 01:26
I'm just not sure how to write the formula, based on which validation option is selected in column C?
Excelchat Expert
17/09/2018 - 01:26
Business days means excluding saturday and sunday correct
User
17/09/2018 - 01:26
correct
Excelchat Expert
17/09/2018 - 01:26
Ok. I will do it and share it with you
User
17/09/2018 - 01:26
Thank you
Excelchat Expert
17/09/2018 - 01:28
FYI
[Uploaded an Excel file]
Excelchat Expert
17/09/2018 - 01:28
Can you please check and confirm the same
User
17/09/2018 - 01:29
THANK YOU!!!
Excelchat Expert
17/09/2018 - 01:30
Do you have any other questions about this problem and the solution?
Excelchat Expert
17/09/2018 - 01:30
I Just created the table and used formula "Workday" to calculate the duration
User
17/09/2018 - 01:30
is it possible to move the "Duration" onto the validation Data Sheet please?
Excelchat Expert
17/09/2018 - 01:31
Sure.
User
17/09/2018 - 01:31
Just so I can hide it from users
Excelchat Expert
17/09/2018 - 01:31
FYI
[Uploaded an Excel file]
Excelchat Expert
17/09/2018 - 01:32
Is it fine?
User
17/09/2018 - 01:32
PERFECT
Excelchat Expert
17/09/2018 - 01:32
Thanks for coming to Excel chat. Feel free to leave any comments or feedback. Have a nice day
User
17/09/2018 - 01:32
Thank you so much, you have saved me so much time!
Excelchat Expert
17/09/2018 - 01:33
Thanks for your feedback ! Request you provide valuable feedback and connect with us again
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.