Filter on date column with random years on Sharepoint

Usecase

You have a sharepoint list with birthdays, on a date column, but dont know how to filter on them to show the last few days or upcoming few days if someone has (had) their birthday.

I couldnt figure out how to do this, and then a colleague of mine Remco Bruijstens (thank you!) suggested this method, and after testing it worked. Kudos to him, and I wanted to share with you how to accomplish this.

Step 1 - Create a calcucated column

There is no way to filter on the existing date column, using [Today] with something like ([Today]-8,"MMDD") It seems reasonable, but it wont work.

So you’ll need to create a calculated column, with the following code:

=DATE(2024;MONTH(Datum);DAY(Datum))

Datum in this case is the Date column of which my birtday dates are in.

what does this do?

This creates a column, with your Month and Day from the Birthday column, with the (current) year 2024 in it. This way you can use [Today] as it uses this year.

Step 2 - Set your filter

Go to your list settings, to the view, and on filtering add the following:

Show when items when column:

• Your column name on the first dropdown
• is greater than or equal to [Today] AND
• Your column name
• is less than [Today]+8

This gives you the current day birthdays, including the upcoming 8 days.

And there you have it, kind of a workaround, but it does the trick.

I forgot to add, make sure to update the 2024 part of the formula on Jan 1st to 2025, it wont do it automatically.