Question description:
This user has given permission to use the problem statement for this
blog.
I need an Excel formula that will return a week day if the results is a weekend.
Solved by M. A. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
14/03/2018 - 09:32
hello
Excelchat Expert
14/03/2018 - 09:32
Hello
Excelchat Expert
14/03/2018 - 09:32
Do you need a formula that return just the week day if the return is weekend?
User
14/03/2018 - 09:33
Yes - So if 4/3/2018 minus 3 days returns a Saturday or Sunday, i would like it to come back as Friday 3/30/18 as opposed to 3/31/18 Saturday
User
14/03/2018 - 09:34
So basically the first weed day prior to Saturday or Sunday
User
14/03/2018 - 09:34
sorry - Week
Excelchat Expert
14/03/2018 - 09:34
let me see
Excelchat Expert
14/03/2018 - 09:35
Do you want the return is a week day and not weekend?
User
14/03/2018 - 09:36
Yes only week day. Thank you.
Excelchat Expert
14/03/2018 - 09:36
ok. Can you wait a moment so I can make the formula to it?
User
14/03/2018 - 09:36
Of course. thanks.
Excelchat Expert
14/03/2018 - 09:42
Can you see the formula?
User
14/03/2018 - 09:42
No - where am i suppose to see it?
Excelchat Expert
14/03/2018 - 09:42
on Document Preview
Excelchat Expert
14/03/2018 - 09:42
=if(WEEKDAY(A1-B1)=1,A1-B1- 2,if(weekday(A1-B1)=7,A1-B1-1,A1-B1))
User
14/03/2018 - 09:43
What does A1 and B1 represent?
Excelchat Expert
14/03/2018 - 09:43
on cell A1 I included the date and cell B1 the number of days to be subtracted
Excelchat Expert
14/03/2018 - 09:43
4/3/2018 4 3/30/2018
Excelchat Expert
14/03/2018 - 09:43
4/3/2018 3 3/30/2018
Excelchat Expert
14/03/2018 - 09:44
4/3/2018 2 3/30/2018
Excelchat Expert
14/03/2018 - 09:44
Is it what you need?
User
14/03/2018 - 09:44
OK let me give that a try.
User
14/03/2018 - 09:45
Yes perfect. Thank you for your help.
Excelchat Expert
14/03/2018 - 09:45
Please give your kind feedback for our service
Excelchat Expert
14/03/2018 - 09:46
Have a nice day :)
User
14/03/2018 - 09:46
Definitely a 10. You are awesome. Thank you.
User
14/03/2018 - 09:46
Where do i make my official feedback?
Excelchat Expert
14/03/2018 - 09:46
I think you need to end the session
User
14/03/2018 - 09:46
Do i need to refer to an Expert #?
User
14/03/2018 - 09:47
Or name?
Excelchat Expert
14/03/2018 - 09:47
So sorry... I don't know how is the screen
User
14/03/2018 - 09:47
it does not show your name, picture or number.
Excelchat Expert
14/03/2018 - 09:47
is there a place to end?
User
14/03/2018 - 09:47
I just want to make sure i provide the feedback for the correct person.
Excelchat Expert
14/03/2018 - 09:47
any button?
User
14/03/2018 - 09:48
Yes i will end the session now. Thanks again for your help.
Excelchat Expert
14/03/2018 - 09:48
you're welcome
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.