Tuesday, October 5, 2021

Upcoming birthday column - without aging your employees!

 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!

No comments: