Excel 2007 : updating a column automatically according to month

Hi All -

I need some help with an excel 2007 problem. I'd like a column to be updated when a month is changed on the sheet. For instance, if the month changes from June to July, then I'd like to add 2.08 to all values in column B. And for this to happen subsequently every time the month changes. The month is currently in the header but I can also create its own column.

Please give me any tips or advice on how to do this.

Thanks

Hi rebpio

you may make a two column table in first column month and second column value you need to add. then on the basis of month+today function pick the from this table to c column and add with b column

Kindly upload a sample workbook if it does not solve your problem