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.