I have a sheet with Name Surname and Day of birth.
I would like to create a new view but only on today’s birthday
But the further that I got is this one:
The filter try to use this current year, so no user get display.
I would like the filter to show any record from 18 February for any year. and not only from 2023.
I suggest making another column
This Year's Birthday, which calculates the date this year to celebrate this birthday on. There are several ways to calculate it; one is:
Set the type of the column to
Date, and then you can create (and save) a filter that only shows rows where this column’s value is today’s date.
It works!. Thanks so much Dmitry!!