**Question description:**

*This user has given permission to use the problem statement for this blog.*

need help with the different sheets and formula IF(A4=B4,0,NETWORKDAYS(A4+1,B4,$E$9:$E$42)
+0.5*(INT((+B4-A4+1)/7)+IF(WEEKDAY(A4+1)+MOD
(B4-A4-1,7)>=7,1,0)))

Solved by O. D. in 11 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
14/12/2017 - 08:16

thank you and welcome for selecting get it pro

Excelchat Expert
14/12/2017 - 08:16

pleaes tell me which formula you want to understand

User
14/12/2017 - 08:16

hi

User
14/12/2017 - 08:17

I want to know about the mid function

Excelchat Expert
14/12/2017 - 08:19

yes

Excelchat Expert
14/12/2017 - 08:19

the Microsoft Excel MID function extracts a substring from a string (starting at any position)

Excelchat Expert
14/12/2017 - 08:19

and

Excelchat Expert
14/12/2017 - 08:19

The MID function is a built-in function in Excel that is categorized as a String/Text Function

Excelchat Expert
14/12/2017 - 08:19

The syntax for the MID function in Microsoft Excel is:
MID( text, start_position, number_of_characters )

User
14/12/2017 - 08:19

yes

Excelchat Expert
14/12/2017 - 08:20

Parameters or Arguments are as below

Excelchat Expert
14/12/2017 - 08:20

like text
The string that you wish to extract from

Excelchat Expert
14/12/2017 - 08:20

start_position
The position in the string that you will begin extracting from. The first position in the string is 1

Excelchat Expert
14/12/2017 - 08:21

number_of_characters
The number of characters that you wish to extract

Excelchat Expert
14/12/2017 - 08:21

Returns
The MID function returns a string/text value

Excelchat Expert
14/12/2017 - 08:21

now i will give you one example

Excelchat Expert
14/12/2017 - 08:23

=MID(B2,5,5)

Excelchat Expert
14/12/2017 - 08:23

i mentioned this formula in sheet

Excelchat Expert
14/12/2017 - 08:23

it give us

Excelchat Expert
14/12/2017 - 08:24

the word from B2 cell andstarted from the 5th letter and after 5th letter consider 5 letter

Excelchat Expert
14/12/2017 - 08:24

is it make sence?

Excelchat Expert
14/12/2017 - 08:24

hello sir are you there

User
14/12/2017 - 08:24

yes

User
14/12/2017 - 08:24

wait please

User
14/12/2017 - 08:24

I will check

User
14/12/2017 - 08:25

yes

User
14/12/2017 - 08:25

thank you

User
14/12/2017 - 08:25

I understand

User
14/12/2017 - 08:25

thanks for helping

Excelchat Expert
14/12/2017 - 08:26

any other help do you need?

User
14/12/2017 - 08:26

not for now thanks

Excelchat Expert
14/12/2017 - 08:26

can i close this session?

User
14/12/2017 - 08:26

yes

User
14/12/2017 - 08:26

thanks

Excelchat Expert
14/12/2017 - 08:26

please help me by rating 5 star sir

User
14/12/2017 - 08:26

sure

Excelchat Expert
14/12/2017 - 08:26

bye

User
14/12/2017 - 08:27

bye

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