Reporting on Dates in the past for Milestones


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 ?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!