Reporting on Dates in the past for Milestones

EHarshbarger

Hello,

I am trying to run a report for upcoming milestone dates for employees such as birthdates and hire date anniversary's. I have the format in a date cell in the Mon/Day/year format. When I run the report the "In the next xx of days" filter does not grab any of my dates as they are in the past. Is there a good way to get the report to work or do I have to re-format my sheet ?

Eric Law

@EHarshbarger You will probably want a helper column that updates the year, name it Anniversary (Or whatever) and use the following formula =DATE(YEAR(TODAY()), MONTH([Hire Date]@row), DAY([Hire Date]@row))