Highlight Weekends Dates and Holidays in Excel (Easy Method)

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.

[@TheLonelymusic]

How to do it for columns using weekends

[@linakristiansson1312]

OMG! Iv been looking for this info for two whole days!!!! Thank you for providing!!

[@lamees1134]

I can not thank you enough for such an informative tutorial. I am very excited to show my co-workers how to organize attendance sheets.

[@revathiindasi748]

That was quite informative and straight to the point. I subscribed to your channel. Please keep sharing your Knowledge

[@CATZILLA_Gaming]

Very helpful video. Cleared my all doubts Thanks sir

[@bhushanbachhav6706]

tHANKS, Bhai, YOU SOLVE MY PROBLEM IN SECONDS...

[@TUTDave]

Thank you, very helpful.

[@sandadi007]

Hello Mr. Sumit, It was an awesome video and an excellent tip for highlighting the weekend entries. However, it is not giving me the desired result when I tried. I am unable to troubleshoot or identify what mistake I have made. Really appreciate it if you let me know as to how I could share my Excel file with you to identify the issue.

[@muthumeena5021]

It is very useful to use my day to day works and tks a Lot sir 🙏

[@Nihalsaviation350]

Please post a video about advance printing options in excel.

[@trumpexcel]

Thanks for the suggestion.. Will create a video on it soon

[@linhhua]

Thank you so much!

[@Joker-Leto]

but how to apply it in a timeleine .. with formulas for weenkend and off weekend? thank you

[@bluffmasterhara]

Great video! How about if I wanted to highlight a specific date of every month lets say .....the 19th, how to do that?

[@donovang6911]

Does this work for columns?

[@langproffeducationcenter6874]

How can I Calculate if my 1st, 3rd and 5th Saturdays are Non Working days including Sundays and 2nd & 4th Saturdays are working? please advise!

[@bhekinkosi419]

Hi, How do you completely remove or hide weekend data automatically from data set even after refreshing your data set?

[@brentcosta3705]

Can we have an example file? Where can we download it? Can you please make it available for everyone?

[@karenwheeler3729]

I find your videos straight to the point and clear thank you. How would you do this for dates that are columns instead of rows?

[@varuninnz]

perfect 100/100

[@digitalresearchsupport8546]

What if I want to delete these highlighted cells ???

[@marcelamartinez8409]

How would you do this for dates that are columns instead of rows?

[@adie0]

Great question. I’m interested to understand this too as timelines are mostly done where the dates are in columns

[@bayarahmed2436]

Thank you sumit, I believe this is the part of your leave tracker template, any chance you would make a tutorial about creating leave trackers ? Thank you !

[@Tracks777]

awesome video

[@alndr4u]

Excel Sheet1 se a3:a25 ki data values sheet2 me b4:b26 me fir c3:c26 me copy paste ho aur aise hi aage aane wali sheet2 ki colomns me paste ho har 5 minutes me iske liye vba bataiye sir... Thank you

[@AbdulRauf182]

Yes help video . Our problem resolved 😉 from this video. Thank you 💓😊

[@manukondarameshbabu6194]

very happy to see your face from a long time i am watching your videos and have a desire of see your face thanks

[@IvanCortinas_ES]

Super video with dates Sumit. Thank you very much!

[@2310546]

How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded

[@Devad2007]

A very useful tip and thank you

[@FaithfulJimJam]

What if you just want to use this formula to just sum the data with the weekend

[@sreejithmurali8041]

Instead of 6&7 it picks 5&6 always when i put >5, any solution

[@Nihalsaviation350]

Good informative video.

[@mor-sbu4862]

Couldn't leave your channel without subscription! Thank you for the amazing videos! From NY, US

[@trumpexcel]

Thank you so much :)

[@stevenhegewald3934]

Hi Sumit. Can you show a way to change a date column from DD/MM to MM/DD? It would help with bank reconciliations. Thanks.

[@trumpexcel]

You can do that using custom number formatting. Select the cells that have the date, hold the Control Key and press the 1 key (this opens the 'Format Cells' dialog box. In Numbers tab, click on Custom and use the following format - MM/DD/YYYY

[@Tracks777]

lovely stuff

[@URFree2watch]

Thanks a lot Sumit 👍🏼 Most of the time i used to add separate columns with formula then link it to conditional formatting thinking that adding main conditional formatting would be difficult or complicated to manage. But your example gave me better understanding.

[@trumpexcel]

Glad you found the video useful Subramanian

[@ValerieCudnikCDG]

Excellent instruction. Clear explanations of what and why things are done.

[@trumpexcel]

Glad you found the video useful 🙂

[@haniideedongss]

omg i love yr explaination

[@KapilMakwana]

what to do on the 2nd and 4th Saturday off day. ??

[@vijaysahal4556]

nice 👍🏻👍🏻👍🏻👍🏻

[@smanikandan9076]

Thankyou sir

[@guesswho9541]

thank you so much for the detailed explanation of how the formula work. one question please, what if the date list is on horizontal side not vertical on column? how to conditional formatting that case?? the formula doesnt work in this case

[@guesswho9541]

oh i just did ittt, just by moving the dollar sign to the middle before the row 😂

[@giorgiosergi1938]

AWESOME

[@piarchanddogra1659]

Very nice.. Thanks for sharing 👍👍

[@trumpexcel]

Glad you found it useful!

[@Sekhar_Home]

Best as always. Most of my problem solved. Hats off to U

[@trumpexcel]

Glad you found it useful!

[@THETECHIENEWBIE]

Great video !!!! I Appreciate your way of teaching !!!!

[@redhaakhund1271]

👍👍👍👍👍

[@oladaposorinola6216]

Interesting, thank you Sumit

[@trumpexcel]

Glad you found it useful!

[@UPSC-rc3jr]

❤️

[@krishnatate4765]

Helpful 😊

[@trumpexcel]

Thank you.. Glad you found the video helpful 🙂

[@breakingbad582]

Hi thanks you so much share us this video. I wanna arrange weekend holiday date especially construction works make biweekly weekend( not every sunday, biweekly sunday- in within 14 days just one day ) is this possible arrange formula weekend holiday?

[@guruprasadbm1987]

Nice Sumit 🙂thanks for sharing your knowledge. I have One doubt, can we filter the data based on only one day. Ex: In any month I need to filter (not highlight) only every Monday's data. Please let me know if you know about this.

[@thedangourytv1020]

Hello Sir I just finished a vba project in Excel . A scoring progam for Taekwondo fight and i want to know if i can enter some code to control it by using gamepad I used the Application.onkey and the xppadder but whitout success so if their any help i ill be gratefull

[@oguzyavuz]

If I delete the dates from the column, all the blank cells become highlighted. Why is that? The cells should be highlighted only the cell value > 5. How can I fix it? thanks

[@redhaal-obaidy2217]

Very helpful Sumit, Much appreciated and I used in my calendar and leave planner, thank you SIR!

[@brightmuffin5530]

Sumit knows how to teach excel better than my professor at university. Sumit is my friend now. I like Sumit.

[@coolag74]

The easiest way. Fantabulous...

[@bonitanance6380]

Thank you so much Sumit! This helped me to prepare my worksheet to explain all of my data!

[@paramsingh383]

sir if i have highlight monday wednesday and thursday ....all so how to do ?

[@blahfroppy]

You are a wonderful person

[@wayneedmondson1065]

Great tips Sumit! Thanks for sharing :)) Thumbs up!!

[@ladyesther3400]

Do you have a video that only highlights the sub-total and total of the data?

[@khae9566]

Thanks a lot Mr Sumit . Your videos very useful and clear .

[@praswanthreddy2673]

What does DDDD refer to?

[@trumpexcel]

It refers to the format that decides how the day part of the date would be shown. D - Shows day value without leading zero DD - Shows day value with leading zero DDD - Show day name is short format (Mon, Tue, Wed...) DDDD - Shows day name in full (Monday, Tuesday, Wednesday...)

[@praswanthreddy2673]

@@trumpexcel thank you so much

[@devanstandley8783]

I spent days on a problem and your video helped out so much

[@cookiemonster11123]

Thank you. Great video, very well explained.

[@kripashanthi]

really good video, useful and no nonsense

[@walidibrahimh1853]

Lovely, you were fast and VERY clear. 🙏

[@rarasatintan]

thank you so much!

[@GeorgeAJululian]

Thank you it is very helpful

[@Planetdhanush]

This was really helpful. Thanks

[@jamesaubry752]

thanks a lot for this, saved me so much time!

[@monvagulati6408]

Thank you this was super easy.

[@weamjasim3255]

Thank you very much!

[@fauziyabafagih6625]

I want my conditional formatting to highlight weekday 5 which is Friday so I used the same formula =WEEKDAY(D2,2)=5 but it highlights every Thursday instead. Any idea why this is happening?

[@fauziyabafagih6625]

I figured it out. This happened when I selected the entire column including the heading. When I selected only the date range, I got the result I wanted.

[@stavrosbatsaktsis8698]

[@kannan1812003]

What if the holiday is a Saturday or Sunday? Will it highlight with blue or orange?

[@SteS]

Depends on where the condition is. Open the conditional format and see the 2 that are in the worksheet and move one above or below to affect the order of preference. You can also uncheck the true in the last column there to suit your needs.

[@RamaeSmith-y5r]

Thanks for posting, this solved my problem.

[@trumpexcel]

Thanks Ramae... Glad you found the video helpful 🙂

[@dotfromrbg8199]

Watched so many videos but only this worked, thankyou

[@trumpexcel]

Glad the video helped

[@mmincredible1451]

Super love u sumit..

[@indiahome5908]

Thank you very helpful

[@trumpexcel]

Glad you found the video useful!

[@kendraklashinsky9605]

Thank you so much for this!

[@trumpexcel]

Glad it was helpful!