| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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! |
|
#4
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
| I need a formula that will sum the top 3 number in a column | Excel Worksheet Functions | |||
| how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Req, Tricky column formula | Excel Worksheet Functions | |||
Hybrid Mode
