View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
justsomeguy justsomeguy is offline
external usenet poster
 
Posts: 12
Default Numbers that self-increment when the year rolls over

One column in a personnel roster spreadsheet contains the number of years
each person has worked for the company. Is there a way to make this number
for each person self-increment (ideally on each person's hire date
anniversary) so the spreadsheet will remain accurate, year after year,
without a lot of manual updating?