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!
|