add a value to the cell value itself
 

I have a value in a cell.I want to add a value to the cell value on 1st
January of every year.How to do it?
Example:
as on 31st January Cell B2=17
I want a formula to add 30 to B2 cell on 1st January
result on 1st January in Cell B2=47
What formula works?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200907/1

add a value to the cell value itself
 

Typo error:Please correct 31st January to 31st December

tkraju wrote:
I have a value in a cell.I want to add a value to the cell value on 1st
January of every year.How to do it?
Example:
as on 31st January Cell B2=17
I want a formula to add 30 to B2 cell on 1st January
result on 1st January in Cell B2=47
What formula works?

--
Message posted via http://www.officekb.com

add a value to the cell value itself
 

Look he

http://www.mcgimpsey.com/excel/accumulator.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tkraju via OfficeKB.com" <u16627@uwe wrote in message
news:98c69e66f6d20@uwe...
I have a value in a cell.I want to add a value to the cell value on 1st
January of every year.How to do it?
Example:
as on 31st January Cell B2=17
I want a formula to add 30 to B2 cell on 1st January
result on 1st January in Cell B2=47
What formula works?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200907/1