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