1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Using Excel to capture milestone anniversaries

Can someone tell me if this is possible? At work, I have an excel with the start dates of our employees. My task is to find everyone celebrating their 5th, 10th, 15th, 20th, etc anniversaries within this fiscal year. I would like to excel to find all the milestones listed. My goal is to have them all be a different color. How can I do this?

submitted by /u/Big-Inspector6686
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#big data management in spreadsheets
#rows.com
#financial modeling with spreadsheets
#Excel
#milestone anniversaries
#employees
#start dates
#fiscal year
#celebrating
#color
#find
#task
#5th anniversary
#10th anniversary
#15th anniversary
#20th anniversary
#milestones
#different color