View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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!