Here is something I needed to do so many times, and I think I finally perfected it.
A simple HR request, is to show the employees upcoming birthdays, in a simple user friendly way without dating your employees! (So, without showing their birth year...)
I've come up with this simple way of handling this, using 3 columns.
First create a choice column for Month (01-12) and for Date (01-31).
Then, create a calculated column with output type "Date", using this formula:
=DATE(IF([Birth month] And boom - you will always get the employee's upcoming birthday in a date column that you can use to display on your site! Explanation about the formula: The formula will check if the birth month has past, and if so will use next year's birthday. Otherwise it will construct a date for the current year based on the month and date you entered before. Want a cool way to show it? Try our Calendar Plus web part: Use our brand new "Card" control:
Want an even cooler way?
Hope this helps!