August seems to be a very popular birthday month among my Excel friends. I won't mention any names here, because most of them are quite elderly, and the shock might upset them. ;-) Anyway, to all of them, and you, if you're celebrating this month -- happy birthday!

The Birthday List

If you're in charge of an employee list, and have to send birthday greetings, or hiring date anniversary congratulations, you can use Excel to help you keep track.

In the worksheet shown below, there are fictitious employee names and birthdates. In a separate column you could use the MONTH function to check which birthdates are in the current month.

This formula compares the month of the date in column C, to the month of today's date. If the months are the same, the result is TRUE.

=MONTH(C2)=MONTH(TODAY())

Highlight Birthdays with Conditional Formatting

Instead of adding another column with

Continue reading Highlight Current Month Birthdays in Excel