Highlight Weekends Dates and Holidays in Excel (Easy Method)

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.

very nice

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

really good video, useful and no nonsense

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

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

Thank you this was super easy.

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

Does this work for columns?

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

❤️

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

Thank you, very helpful.

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

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?

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

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

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

omg i love yr explaination

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.

A very useful tip and thank you

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.

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

Thankyou sir

Subscribe 👍 Don

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

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

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!

AWESOME

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

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

Thank you it is very helpful

Thank you very much!

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?

Very helpful video.
Cleared my all doubts
Thanks sir

👍👍👍👍👍

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

You are a wonderful person <3 thankyou so much for this! It was very helpful!

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

nice 👍🏻👍🏻👍🏻👍🏻

Thank you very helpful

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

Watched so many videos but only this worked, thankyou

Lovely, you were fast and VERY clear.
🙏

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

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

Thanks, very useful. For highlighting holidays, I used this formula =IF(MATCH($A2,$Holidays,0),TRUE,FALSE). Works better than VLOOKUP.

<3

Thank you. Great video, very well explained.

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