Excel - IF Function Problem - Expert Solution

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
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.

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.