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]<TEXT(TODAY(),"MM"),YEAR(TODAY())+1,YEAR(TODAY())),[Birth month],[Birth date])
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:
Want an even cooler way?
Use our brand new "Card" control:
Hope this helps!
