Highlight Weekends Dates and Holidays in Excel (Easy Method)

In this video, I will show you how to quickly highlight weekend dates in Excel using conditional formatting.

It also covers how to highlight records where a date is a holiday.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[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.

[ValerieCudnikCDG]

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

[karenwheeler]

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?

[linakristiansson]

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

[lamees]

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.

[mor-sbu]

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

[redhaal-obaidy]

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

[AbdulRauf]

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

[IvanCortinas_ES]

Super video with dates Sumit. Thank you very much!

[Yeld_Nats]

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

[jamesaubry]

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

[dotfromrbg]

Watched so many videos but only this worked, thankyou

[CATZILLA_Gaming]

Very helpful video.
Cleared my all doubts
Thanks sir

[manukondarameshbabu]

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

[Sekhar_Home]

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

[guesswho]

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

[bayarahmed]

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 !

[brightmuffin]

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

[marcelamartinez]

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

[khae]

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