Excel date arithmetic problem
November 14, 2008 9:55 AM Subscribe
MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today?
posted by Rock Steady to computers & internet (13 answers total) 1 user marked this as a favorite
I am trying to calculate employee discount levels. For every year of service, an employee gains an additional percentage discount. I have employee hire dates in an Excel spreadsheet, and I would like to be able to, at a glance, determine what discount level a given employee is at, even if I open the spreadsheet three years from now. The levels top out at five years, if that matters.