Given a date, what formula will highlight other dates in the same month and year?

What formula would you use to apply conditional formatting? Please post your answers in the comments section below. Like so many things in Excel, there are many ways to solve this problem. Need some ideas or inspiration? You can find Excel’s date functions here. There’s a practice file attached below so you can easily try out your ideas. Remember that conditional formatting rules need to return TRUE (or equivalent) to trigger formatting. In the example above, cell E2 is named “date” for convenience. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Highlight dates in the same month and year - 26Highlight dates in the same month and year - 97