Help with a date code

Hello everyone, Sorry not sure where to put this question, i was wondering if i could get some help with a form im trying to make. Basically i have a number that i want to increase by 1 each month. So lets say the number is 13. Right now it is october, in november i would like Excel to automatically change that number to 14 and and so on each month without me having to manualy do it. i was trying to figure it out using the Now() code so that excel will automaticaly change the date each month but im not sure if this is the right way of going about this. Any help would be greatly apreciated.This list is basically the number of points someone has so they all have different numbers. I have a list of say 10 people all with a different number of points like this:

John:20
Lisa:16
Kenny:12

and so on, im trying to figure out how would i use a code that would automatically increase there specific number by 1 each month without me manualy having to do it, Thank you.
Bacarat

Thank you so much works perfectly

cool i get it now one question what does the 12* at the end of the forumla mean(just tying to understand the coding a little better)

Glad I could help...

*12 allows you to multiply by 12, as soon as you go into next year, and keep adding months ...

Thanks for the feedback

Carim