Hi ,
I am trying to create a dashboard and want the list of people who have their birthdays this week displayed there. This should help me to see the list and go ahead and wish them.
Sheet 1 has the complete data of folks with their names and date of birth(Column I and AC2 respectively). The date is in YYYY-MM-DD format
Sheet 2, the dashboard should display the list of people with birthdays as of today.
N3 O3
Names Date (MM-DD)
---------------------------
I tried the filter function but it gives me an error.
=FILTER('US_India Employees'!$I$2:$I$998,TEXT('US_India Employees'!$AC$2:$AC$998,"MM-DD")=TEXT(TODAY(),"MM-DD"),'US_India Employees'!$C$2:$C$998,"Active","No birthdays today")
Bookmarks