Thread: add a value to the cell value itself
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tkraju via OfficeKB.com tkraju via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default 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

Reply With QuoteReply With Quote