Excellent presentation. One thing is that, you never ask either at the beginning or end of the video for subscribing. You always end the video with same note and in same style.
sir u r awesome I learn l lot , will u plz help me to solve a problem, There is a doc which expiry is in next 6 month from the date written on the doc how can i set remainder alarm on it on a specific date. What is the logical function I use?
If there are multiple months, and I want to know for each month how many days? Ex: (16-10-21 to 15-12-21) - October- 15 Days, Nov - 30 Days, Dec - 15 Days
Doubt? If I need to calculate the NetworkDays of an employee in my Org where the weekly offs (2 days) is dynamic i.e, not compulsorily same days every time. How can I calculate it using this function? Or some other function should be used? I was just checking the usage of this function in all possible ways to learn excel better. Hope to get an answer from you SIr or anyone in the forum.
I have query that if I have data that is storing form to Excel and in excel there is dropdown that is for current date which means whenever we are selecting a particular row it will display the date of selecting.
Sir TYSM for these videos, I learnt a lot. I have one question, in this video is there any way put holidays in NETWORKDAYS() and NETWORKDAYS.intl() if they are written in alternate cells like L8 and L11 and L3. I tried by separate them with ":" but it gave the wrong result. so is it necessary to write the multiple holidays in the cell beside each other?
Please Help me sir , if i want to make a net days calculation with 52 weekend how can i do it . I'm trying but it doesn't not work properly .My Country weekend only Friday.
At 2:41 what's problem in writing 2? It isn't giving same result after writing 2 but excel should give same result considering Sat & Sun. If one of them comes under Sat & Sun, result= actual result -1. If both of them comes under Sat & Sun, result= actual result -2. Isn't it so?
hi... if i want to calculate how many fridays i have got as an off in my organization for 1 year and i need to compare my offs with other employees friday offs... how cn i do that
By weekend option it is not possible as there some fixed week off has given. you can try to add 2nd & 4th Sat separately by adding them in holidays. Hope it work
sir, I have try to find the working days in a year but after i put formula then enter there is wrong how can i fix the problem. Please tell me the solution.
Sir I have one question when i put start date its come on the right side of the cell (1-1-2024=1/1/2024) but when i write end date its dose not go right side its come on left side (31-12-2024=31-12-2024)
Hello Anamika. If you didn't understand date vs days, no worry. It's just to know which day of the week a certain date is. For example 10 October 2020. You want to know the day of the week of this date. You can have a look at the calendar & it'll show you that it's Saturday. But it's difficult to look for each date in a long list. That's why he explained how to custom it. But you can also use this formula: =TEXT. For example, in cell A5 you have 10-10-2020. If you type in any cell: =TEXT(A5,"DDDD"), it will show you the day of the week. Similarly, you can use the same formula to show the year or month.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Excellent teaching style by Pavan Lalwani sir. Thank a lot for every tutorials point
Excellent presentation. One thing is that, you never ask either at the beginning or end of the video for subscribing. You always end the video with same note and in same style.
9kk
Best Excel teacher i have ever seen🙏
*You're the best, sir.*
Hello, thank you. Good again. I'm sure you know this, but we can also use =Text function to show the day of the week of a certain day.
Very Very Nicely explained. Thanks a lot.
Very good. Keep up the good work. God bless you.
respected sir
I have gone through some of your excel videos ,they are excellent videos
Please upload videos of access2007
Simple and amazing; thanks for the video
Very Good videos And Very Easy explanation.
Your smile is speaking something
When we refer your video we can learn full excell clear
Love and respect form Afghanistan
Sabbash guru . Excellent .
sir u r awesome I learn l lot , will u plz help me to solve a problem, There is a doc which expiry is in next 6 month from the date written on the doc how can i set remainder alarm on it on a specific date. What is the logical function I use?
good...respected sir...thank you
Thank you sir
If there are multiple months, and I want to know for each month how many days? Ex: (16-10-21 to 15-12-21) - October- 15 Days, Nov - 30 Days, Dec - 15 Days
Thank you Pavan Sir.
God bless you!!!
THANK YOU
thank you
Doubt? If I need to calculate the NetworkDays of an employee in my Org where the weekly offs (2 days) is dynamic i.e, not compulsorily same days every time. How can I calculate it using this function? Or some other function should be used?
I was just checking the usage of this function in all possible ways to learn excel better.
Hope to get an answer from you SIr or anyone in the forum.
Thanks sir
I have query that if I have data that is storing form to Excel and in excel there is dropdown that is for current date which means whenever we are selecting a particular row it will display the date of selecting.
2016 is a leap year!!!
Sir TYSM for these videos, I learnt a lot. I have one question, in this video is there any way put holidays in NETWORKDAYS() and NETWORKDAYS.intl() if they are written in alternate cells like L8 and L11 and L3. I tried by separate them with ":" but it gave the wrong result. so is it necessary to write the multiple holidays in the cell beside each other?
very nice video
Thank you😊😊😊❤❤
Excellent
just wow
Hello , i have a problem on my excel program, the sign on left side on the top , to go back is missing, how can I fix this problem please
Please Help me sir , if i want to make a net days calculation with 52 weekend how can i do it . I'm trying but it doesn't not work properly .My Country weekend only Friday.
At 2:41 what's problem in writing 2? It isn't giving same result after writing 2 but excel should give same result considering Sat & Sun.
If one of them comes under Sat & Sun, result= actual result -1.
If both of them comes under Sat & Sun, result= actual result -2.
Isn't it so?
Super 👍
hi...
if i want to calculate how many fridays i have got as an off in my organization for 1 year and i need to compare my offs with other employees friday offs... how cn i do that
How do I make a function go back to the week day if it falls on week end sorry for example if it falls on sat -1 and sun -2
I've tried to use custom date option but value is not same in formula tab and cell value
How do I calculate work days if there are holidays Every Sunday and 2nd & 4th Sat?
By weekend option it is not possible as there some fixed week off has given. you can try to add 2nd & 4th Sat separately by adding them in holidays. Hope it work
I tried and it worked. Hope it is helpful. :)
@@gitanjalikumari9636 thanks
Sir nice video
Sir Networkdays function me Date Manually Nhi lega kya. only take cell reference ?
Superb
well it doesnt get customised in 2019 version what can we do now?/
We have all Sundays off and alternate Saturdays off, how do we calculate net working days?
I used the same formula to find the number of days between two dates..but the result came in the form of mm/dd/yyyy
Hi, I want increment in date in one column as per time changes in another column. How it is possible?
Thanks
Not getting net work days from this formula, getting Error(#Value!) pls help .
same problem bro what can e solve this problem
SAME PROBLEM
Hello Jatin. What exactly do you want to do? Maybe I can help you. Serdar.
How to filter in maximum date formate
What about bank leaves in our country as 1st And 3rd saturday is offday.
sir, I have try to find the working days in a year but after i put formula then enter
there is wrong how can i fix the problem. Please tell me the solution.
@Rishi Akkewar
क्या error आ रहा है?
Nice video
Date functions 2parts, both of them are very confusing :(
But 2016 was leap year so no. of days should be 366
My name is Umair Khan from pakistan can i ask a question?
date function not working what i can do know?
Hello Sir how to re arrange DOB having different years but have arrange to the same month?
Please use a helper column.
1. In a separate column, please use MONTH function to find the months.
2. Sort using this helper column.
How to calculate date of only Sunday leave , I work in a small company.
20/12/23
what if the weekend is monday wednesday and not consecutive days?
Hello iSiri. It's not a problem. You can customize it. If you want I can show you how to do it.
If we count Saturday also in working day?
How can we do sir?
Plz reply
Sir or anybody knows
Please change the 3rd argument - from 4 to 11 . . as follows:
=NETWORKDAYS.INTL(B8,B9,11,D11:D12)
how to remove special characters in an excel sheet?
What if only 2nd and 4th saturdays are holiday
Please show the date putting orderly
Hello Lizy. What exactly do you want to do? Maybe I can help you. Serdar.
In year 2016 there were 366 days
Nice
Didnt get the date v/s day...
How to find start order date and end order date
Sir I have one question when i put start date its come on the right side of the cell (1-1-2024=1/1/2024) but when i write end date its dose not go right side its come on left side (31-12-2024=31-12-2024)
Sir these formulas are not working i
i need help i have to find workdays but not getting result according you sir
Hello Nikhil, what exactly do you want to do. Maybe I can help you.
4:24 what is the shortcut for date without using =today() ?
ctrl + ;
@@bdivyasai3231 thanks
Unable to get the day... When changing format. The last part of the video. ??
Did anyone get tht ?
Yes i got that
Hi how do I contact you
Hi
Your screen is blur unable to view
Sir when i am dragging years are increasing
Hii sir,
Same formate try kiya...
But networkdays.intl formula weekend only Thursday kiya to ans networkdays se jyada Mila ..
Aisa q???
Because networkdays consist holidays on Sat n Sunday if you have one holiday in week then there will be more working days
Didnt get the date v/s day... so confusing
Hello Anamika. If you didn't understand date vs days, no worry. It's just to know which day of the week a certain date is. For example 10 October 2020. You want to know the day of the week of this date. You can have a look at the calendar & it'll show you that it's Saturday. But it's difficult to look for each date in a long list. That's why he explained how to custom it.
But you can also use this formula: =TEXT. For example, in cell A5 you have 10-10-2020. If you type in any cell: =TEXT(A5,"DDDD"), it will show you the day of the week. Similarly, you can use the same formula to show the year or month.
Not getting net work days from this formula, getting Error(#Value!) pls help .
You maybe using excel 2007 or older
@@jaypratapsingh6953 im using 10 but same problem
Thank You