# Excel - IF Function Problem - Expert Solution

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

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.