Will Excel let me automatically add 1 to each number in a column?

[Guest]

I have a monthly roster on which we list each employee's Months of Service.
Is there a way in which I can get Excel to add "1" to the months of service
without doing it manually each month? (I copy the previous month's roster,
rename it, make updates for new hires, terms, etc.)
Someone tried to write a Macro to do it automatically, but it's not working
consistently. I do have some exceptions, too...I cannot add months of service
for those who are on Leave of Absence or who are Reserve Work Force (there is
a column on the roster to list those statuses...)
Thanks very much!!

 

[Guest]

If you have a start date in your spreadsheet, try this.
=ROUNDDOWN((NOW()-A2)/30,0.2)

You may have something that looks like this.

start date name mths of service
1/1/2006 Mike 8.00

You can limit the number of zeros after the period by decreasing the decimal.

Hope this helps.

Mike F.

 

[Guest]

Thanks for the suggestion, Mike...I added a column for start dates and tried
the formula, but I must be doing something wrong...it gave me an error
message.
I have (A) Last Name; (B) First Name; (C) Start Date, written M/D/YY; (D)
Months of Service.

 

[Guest]

You will need to change the formula slightly. If your start date is in
column C then you need to change the -A2 to -C2. A2 represents the cell for
start date. In your case cell C2 represents the start date. Let me know if
this fixes it.

Mike F.

 

[Guest]

Thank you! I will give it a shot!

You will need to change the formula slightly. If your start date is in
column C then you need to change the -A2 to -C2. A2 represents the cell for
start date. In your case cell C2 represents the start date. Let me know if
this fixes it.

Mike F.

 

[Guest]

Mike, you SO ROCK!!!! This is just the coolest thing...
Does the formula work based on the date on which you have the file open? Is
that what the () is for?? It's working beautifully; I'd just like to know
more about HOW it works!
You are a godsend...thanks again for your help!