Hello! I have a table of employees, with their name, work start date, and birthdate, as columns. I’d like to create another table to show me only the employee names whose birthdays and annual work anniversaries are coming up within the next 7 days based on today’s date. I’d love to also calculate, in this table, the number of years they have been at the company.
This sheet should update automatically every day to include only the employees who have birthdays and annual work anniversaries within the next 7 days, and should remove the employees who no longer match that criteria.
Is this possible in Airtable, and if so, how should I create this table?