counting specific weekday in between dates

Key Takeaways

okay guys this is the interview question asked by one of the mnc company in hyderabad to count how many sunday saturdays or any sunday or monday or a tuesday or wednesday any any day to find how many with this in a week so in a particular start date and end date if they give start date and end date you have to find them either sunday monday tuesday wednesday anything to count i'll show you these two formulas okay i'll show you the two formulas one is complex formula that is array constraint and another one is simple formula okay so first of all i will show you the complex formula okay now see no indirect every time i'll use this one start dip i will do like this this this indicates in excel this indicates from okay so what you'll do here i'm percent double quote this one this one ampersand and this one f9 so it will give you like this but you want all dates between these two numbers you can every date okay so what you'll do i use one function called indirect but it will give you the errors you can't use more than eight one line two characters okay so here is to remove that one use this one see all dates between start and end dates it is a number format now convert what you want i want to be convert this all dates into dates or four okay f9 so it will give you all weekdays monday tuesday wednesday thursday friday like this now what you'll do just i will use equal to after this one okay it will give you error because it's nothing is that okay so i suspend this formula for a while here i will use sunday now i'll come back and see whether at night see wherever it finds the sunday it will show us this true remaining or all falses okay so let's see it will work or not convert true and falses by using true as a one and false zero by using mathematical operator because here is there another one is there so you have to wrap that one into this now press f9 see how many are there one two three four just count those things thumb product enter there are four sundays if i change january 0 one [Music] zero one two zero two one so in a uh january from first to end of the january that is 31 january it is five sundays if i change this to monday it will show you all mondays okay this is the one method and another method is very simple you use network international and start date will be this end date will be this and everyone thinking that why don't you use sunday directly so it will give you the errors 11. and not error see but we need four answers so there is a amazing thing that i'll take this one okay i'll take this one previously what i did i did that one only okay i have selected the cell just to press enter it will give you num error so there is a i'll show you 0 is a working day and one is non-working day non-working day non-working output like this how you know this one okay here it is the function i'll show you here if you go to help here they will mention that one zero is in working day and one is non-working day one represent non-working day zero represent working day one represent non-working day okay and zero represent working day so what i'll do here zero starts from non-working day okay zero monday starts for monday okay we need only sundays okay you have to make it holiday on that sunday so it will start from uh non-working day one monday tuesday wednesday thursday friday saturday sunday so it will give you errors okay how to read of this convert this into text by single quote okay so why what is counting is counting how many are there f2 wait a minute one two three four five six seven yes five only monday okay i'll make it like this let's see zero one monday tuesday wednesday thursday friday saturday and sunday so it's not working so this is the right one monday tuesday wednesday thursday friday saturday and sunday right giving five when it is only four okay we'll go to the current month okay the current is equal to today not today okay make it today okay see four sundays are there it's working perfectly here means in february four sundays are there is it right right four sundays are there in february okay this is the easiest method and make sure that which one you want to make to count the weekday you have to make it as a working day and remaining or non-working day simply it will count that weekday okay one is known it's think of three words okay one is non-working day you have to go to office zero is working day so it's a holiday okay so that concept i have used this one and if you have any doubts ask me in the comment box this is one of the reputed company asked this query okay thank you guys thanks for your support and please i request everyone to share this video to everyone so that everyone will know they will get some idea okay these are the two methods one method is this one second method is this one okay thank you guys thanks for your support signing off the nikon