How to Highlight Weekend Dates in Excel?
When working with dates in MS Excel, you may sometimes need to highlight only specific days of the week.
For a sample, you may have a list of dates where you want to highlight all the weekend dates.
It can quickly be done using Conditional Formatting with a bit of formula know-how.
In this tutorial, MS Excel VBA will show you how to highlight the weekend dates in a date data set. The method covered here can also be used to highlight any dates (say Mondays or Tuesdays or alternate days)
Highlight Weekend Dates Using Conditional Formatting
Conditional Formatting in Excel allows you to assess the value in a cell and then apply it to format if the specified requirement is met.
We can use Conditional Formatting to explore the data in a range of cells, and if the date lies on the weekend, highlight it.
Below I contain a dates dataset where I want to highlight all the dates that occur on a Saturday or a Sunday.
Below are the steps to do this:
- Select the cells that contain the dates
- Click the Home tab
- In the Styles Of group, click on Conditional Formatting icon
- In the options that appear, click on ‘New Rule’ option
5 In the ‘New Formatting Rule’ dialog box, click on ‘Use a formula to determine which cells to format.
- Enter the following formula in the formula field: =WEEKDAY(B2,2)>5
- Click the Format button
- Specify the formatting (I will go with the Yellow fill The color)
- Click OK
- Click OK
The above steps would highlight those dates that are either a Saturday or a Sunday.
If the result of that formula is TRUE, then the cell is highlighted in the specified color (yellow in this example), and if the result of the formula is FALSE, then nothing happens.
If the result of that formula is TRUE, then the cell is highlighted in the specified color (yellow in this example), and if the development of the formula is FALSE, then nothing happens.
Highlight Only Sunday Dates
Use the below Mention formula in Conditional Formatting to only highlight dates that occur on Sunday:
=WEEKDAY(B2,2)>6
Highlight Specific Days of the Week
If you want to highlight specific days of the week, you can do that using a simple OR formula with the WEEKDAY formula in conditional formatting.
Below is the formula that will highlight only those dates that occur on a Tuesday or a Thursday: =OR(WEEKDAY(B2,2)=2, WEEKDAY(B2,2)=4)The above OR formula checks whether the WEEKDAY formula for the date returns 2 or 4 (where two is for Tuesday and four is for Thursday).And in case any of these two WEEKDAY formulas return a TRUE, the OR formula also returns a TRUE.So this is how you can use a simple formula in Conditional Formatting to highlight weekend dates (or specific weekdays) in Excel.I hope you found this helpful tutorial!
I all the time used to read paragraph in news papers but now as I am a user of net thus from now I am using net for articles, thanks to web. Micah Saintamand
I admire your piece of work, thankyou for all the great articles . Darin Malave
Howdy! This is kind of off topic but I need some guidance from an established blog. Whitney Wally
Ahaa, its good discussion regarding this article at this place at this blog, I have read all that, so now me also commenting here. Cameron Forbush
Your style is so unique compared to other folks I have read stuff from. Olin Kamat
There is definately a great deal to know about this issue. Shelby Voita
Some genuinely superb articles on this internet site , appreciate it for contribution. Antony Denooyer
Watch Free Hd Pon Hot Porn Hd Pon Videos and Download it. Watch Free Hd Pon Video Hot Porn Hd Pon Video Videos and Download it. Doug Vadenais
That may be the end of this post. Right here youll find some web-sites that we believe youll enjoy, just click the links. Lester Wojtecki
I think the admin of this site is truly working hard for his website, since here every material is quality based stuff. Ivan Kissler
Mijn dochtertje had ze al gezien. Mooi cadeautje voor het 7de verjaardag de 25 ste. Porter Kuna
What a material of un-ambiguity and preserveness of precious experience on the topic of unexpected emotions. Freddy Kniceley
Useful info. Lucky me I discovered your site by chance, and I am stunned why this coincidence did not came about in advance! I bookmarked it. Ian Carrell
I have recently started a web site, the info you offer on this web site has helped me tremendously. Thank you for all of your time & work. Leo Khubba
Absolutely indited content material , thanks for selective information . Deon Cagey
Wonderful post! We are linking to this particularly great post on our site. Keep up the good writing. Blaine Mrazek
I truly appreciate this blog article. Keep writing. Shelby Olpin
I conceive you have observed some very interesting details, thank you for the post. Wesley Vandawalker
Thank you ever so for you article. Really looking forward to read more. Really Great. Roland Sandborg
Everything is very open with a very clear explanation of the challenges. Mario Rathe
Awesome blog. Really looking forward to read more. Cool. Garland Campoy
There is definately a lot to find out about this issue. I love all of the points you have made. Marcel Pichon
Hello. This post was extremely remarkable, particularly since I was investigating for thoughts on this issue last Sunday. Steve Goolsbee
Silahkan click bagian lowongan kerja Waiter. Syarat dan tata cara melamar ada didalamnya. Terima kasih. Lanny Denice
This is one awesome blog article. Really looking forward to read more. Really Cool. Miles Quatraro
Thanks for sharing your info. I really appreciate your efforts and I am waiting for your further write ups thanks once again. Leland Claycomb
Really appreciate you sharing this blog article. Really thank you! Really Cool. Lowell Flamenco
Ahaa, its fastidious discussion concerning this article at this place at this webpage, I have read all that, so now me also commenting at this place. Antonia Christmas
I am genuinely grateful to the holder of this site who has shared this enormous piece of writing at at this time. Jerald Pitzer
You made a number of fine points there. I did a search on the theme and found mainly persons will have the same opinion with your blog. Marcus Keipe
Excellent article! We will be linking to this particularly great post on our website. Keep up the great writing. John Hartsell
Hi there Dear, are you truly visiting this site daily, if so afterward you will definitely obtain nice knowledge. Hayden Nunley
Hi there Dear, are you in fact visiting this web page daily, if so then you will definitely get good experience. Gayle Malueg
I like to hike in the spring when the snow from the mountains is melting and feeding the rivers and waterfalls. Clement Kettman
Make sure that you have SEO friendly themes, plug-ins and templates. Bruce Olcus