MS Excel - Date Functions Part 2 Watch More Videos at: www.tutorialspoint.com/videot... Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
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 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?
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.
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
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
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.
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
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?
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.
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 "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Excellent teaching style by Pavan Lalwani sir. Thank a lot for every tutorials point
Best Excel teacher i have ever seen🙏
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
Simple and amazing; thanks for the video
Very good. Keep up the good work. God bless you.
*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.
Love and respect form Afghanistan
respected sir
I have gone through some of your excel videos ,they are excellent videos
Please upload videos of access2007
Thank you Pavan Sir.
Very Good videos And Very Easy explanation.
good...respected sir...thank you
Sabbash guru . Excellent .
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?
Your smile is speaking something
God bless 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.
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?
When we refer your video we can learn full excell clear
Excellent
Thank You
very nice video
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
2016 is a leap year!!!
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
Thank you😊😊😊❤❤
Hi, I want increment in date in one column as per time changes in another column. How it is possible?
THANK YOU
Thank you sir
Thanks
Superb
Super 👍
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.
thank you
Nice video
Sir nice video
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
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
just wow
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?
I've tried to use custom date option but value is not same in formula tab and cell value
We have all Sundays off and alternate Saturdays off, how do we calculate net working days?
Sir Networkdays function me Date Manually Nhi lega kya. only take cell reference ?
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
Date functions 2parts, both of them are very confusing :(
What about bank leaves in our country as 1st And 3rd saturday is offday.
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.
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
well it doesnt get customised in 2019 version what can we do now?/
How to filter in maximum date formate
How to calculate date of only Sunday leave , I work in a small company.
Nice
Didnt get the date v/s day...
My name is Umair Khan from pakistan can i ask a question?
Unable to get the day... When changing format. The last part of the video. ??
Did anyone get tht ?
Yes i got that
But 2016 was leap year so no. of days should be 366
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.
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 remove special characters in an excel sheet?
What if only 2nd and 4th saturdays are holiday
date function not working what i can do know?
4:24 what is the shortcut for date without using =today() ?
ctrl + ;
@@bdivyasai3231 thanks
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.
In year 2016 there were 366 days
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.
Hi how do I contact you
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)
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 आ रहा है?
Sir these formulas are not working i
Please show the date putting orderly
Hello Lizy. What exactly do you want to do? Maybe I can help you. Serdar.
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
20/12/23
How to find start order date and end order date
Sir when i am dragging years are increasing
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)
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.
Hi
Your screen is blur unable to view
Thanks sir
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