Write formula to add "1" to each number in a column
 

I need to know how to write a formula that will add "1" to each number in a
given column. It's a spreadsheet that shows "months of service" and it needs
to be updated monthly. It's a pain to go through and do it manually - is
there a formula that will work??
Thanks much!

If you have the Date started in A1, this may do what you are asking:
=TODAY()-A1
Then, select the cell with the formula and give it the Custom Number Format
"m" (without the quotes).

tj

"GrannyLib" wrote:

I need to know how to write a formula that will add "1" to each number in a
given column. It's a spreadsheet that shows "months of service" and it needs
to be updated monthly. It's a pain to go through and do it manually - is
there a formula that will work??
Thanks much!

It is not a date, actually, just a number showing the total months of
service. I did find out I can have "1" added to each cell by creating another
column and entering "=C5+1" then dragging down the length of the column to
get the new numbers, but I was wondering if there were another way that would
not involve either cutting/pasting or hiding a column (can't delete original
column because then the reference for the formula is gone!)
Thanks though!

"tjtjjtjt" wrote:

If you have the Date started in A1, this may do what you are asking:
=TODAY()-A1
Then, select the cell with the formula and give it the Custom Number Format
"m" (without the quotes).

tj

"GrannyLib" wrote:

I need to know how to write a formula that will add "1" to each number in a
given column. It's a spreadsheet that shows "months of service" and it needs
to be updated monthly. It's a pain to go through and do it manually - is
there a formula that will work??
Thanks much!

You can put 1 in a cell and copy it.
Then select the numbers you want to add one to. Then, Edit | Paste Special |
Add.

tj

"GrannyLib" wrote:

It is not a date, actually, just a number showing the total months of
service. I did find out I can have "1" added to each cell by creating another
column and entering "=C5+1" then dragging down the length of the column to
get the new numbers, but I was wondering if there were another way that would
not involve either cutting/pasting or hiding a column (can't delete original
column because then the reference for the formula is gone!)
Thanks though!

"tjtjjtjt" wrote:

If you have the Date started in A1, this may do what you are asking:
=TODAY()-A1
Then, select the cell with the formula and give it the Custom Number Format
"m" (without the quotes).

tj

"GrannyLib" wrote:

I need to know how to write a formula that will add "1" to each number in a
given column. It's a spreadsheet that shows "months of service" and it needs
to be updated monthly. It's a pain to go through and do it manually - is
there a formula that will work??
Thanks much!