# Excel - COLUMN Function Problem - Expert Solution

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
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
Excelchat Expert 17/09/2018 - 01:21
Ok...
Excelchat Expert 17/09/2018 - 01:21
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
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
Excelchat Expert 17/09/2018 - 01:24
P1 to P3 = Received date+1
Excelchat Expert 17/09/2018 - 01:24
Excelchat Expert 17/09/2018 - 01:24
User 17/09/2018 - 01:24
P1 - P2 = Date Received
Excelchat Expert 17/09/2018 - 01:24
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
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.