daveturner80
New Member
- Joined
- May 11, 2011
- Messages
- 18
I have a spreadsheet that we use to award service pins when our members reach different years of service.
In column A we have members names and in column C we have their start date. Columns D thru Q are years where we put in a 1 for every year of service. Column R sums up Columns D thru Q. In the next column I would like to put in the members years of service and have it just put in the number of years in increments of 5 years, so if a member has 5 years it would put in a 5, but if he had 8 years the cell would just be blank. Would this be possible to do fairly easy?
Thanks for any help.
Dave
In column A we have members names and in column C we have their start date. Columns D thru Q are years where we put in a 1 for every year of service. Column R sums up Columns D thru Q. In the next column I would like to put in the members years of service and have it just put in the number of years in increments of 5 years, so if a member has 5 years it would put in a 5, but if he had 8 years the cell would just be blank. Would this be possible to do fairly easy?
Thanks for any help.
Dave