Hi Mr. Bansal. Thanks for all your videos. Extremely useful and great source. Could you please help us with different types of job roles/freelance jobs on Excel? I am new to Excel and wanna explore opportunities on Excel.
That's was nice but if I want only weekends (Sat & Sun), how should I do it. And also I cannot see Auto fill option instead it is showing Quick analysis . I have Excel Fill handle feature enabled in Excel options.
For Weekends only, try this formula - =IF(WEEKDAY(B1+1,2) Editing --> Fill --> Series. This will open a dialog box where you can select weekday option. Unfortunately, there is no option for Weekends only, so the formula method would work better
Hi Sumit, Can you please start Google Sheets automation course here, i am looking for this but no where available FMS, PMS, IMS. I want to learn automation
Both techniques are Awesome. I like explanation between the time line 04:00 to 04:10☺️
Learning english and Excel together
Sir,
Thank you for the video. Also learned to extract only weekend days by watching your previous video on weekend days.
Thanks for your video, but my version for the same would be, workday.intl(a1,1,"0000011") it is more optimised to achieve the desired result.
Thank you Sumit. Fabulous techniques
I am always thankful for the handy tricks.
Your excel videos are great. Please consider launching basic to advance tutorials on Microsoft word and PowerPoint too.
Hi Sumit, it's been long time bro. Keep sharing the videos so we will not forgot your refreshing videos.
Hi Sumit, it is good to see your video after a long time. Thanks for this.
Good to see you back uploading videos👏
Thanks, very userful
Hi, What happens if the first date of the month falls on a Sunday? Will this formula still work?
Hi sumit,
Thank you for ur tutorial after long time. I hope you doing well
Very useful tip. Thanks.
I like your videos. Keep posting more and more.
Glad you're finding the videos useful. Next video coming next week
Hi sumit, glad to see your viedo after a long time . Kindly continue power query playlist .
Long wait comes to an end.
Excellent. thanks!
Helpful ❤
I’m new subscriber thank you bro.. keep doing..
Thank u Summit for this great video 📹 👍
Thanks for commenting... Glad you liked it 🙂
Hi Bansal, this video was really helpful. Could you please confirm if we can exclude both Holidays and Weekdays using WEEKDAY formula
Hello , can you share a video on preparation of training calender in excel
Hi Sumit, Super as usual. Can you pl share some logical formulas / functions videos like if(And), if(Or)
Hi Mr. Bansal. Thanks for all your videos. Extremely useful and great source.
Could you please help us with different types of job roles/freelance jobs on Excel? I am new to Excel and wanna explore opportunities on Excel.
Do you have a video tutorial on how to create a leave tracker?
Nice explain
That's was nice but if I want only weekends (Sat & Sun), how should I do it. And also I cannot see Auto fill option instead it is showing Quick analysis . I have Excel Fill handle feature enabled in Excel options.
For Weekends only, try this formula - =IF(WEEKDAY(B1+1,2) Editing --> Fill --> Series. This will open a dialog box where you can select weekday option. Unfortunately, there is no option for Weekends only, so the formula method would work better
@@trumpexcel thank you, let me try
workday.intl(a1,1,"1111100") put the date in cell a1 and then drag or use WORKDAY.INTL(DATE(2022,8,1),ROWS($A$1:A1),"0000011") and then drag.
You did a great job is there any way to get certificate of course completion?🎉
Hi Sumit, Can you please start Google Sheets automation course here, i am looking for this but no where available FMS, PMS, IMS. I want to learn automation
i have a standard price list .and i want to kmow whther vendor following that data when they submit the approval. How to do in Excell ?
SUPER
Hi; Need some help with a formula; Can you help or direct me to the video that yo may have set up Regards Rav