# auto increase cell value on specified date

#### angelik

##### New Member
I am an Excel novice so bear with me please!

How do I get a cell to automatically increase its value by 1 on a set date each year?

Thanks

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hi and welcome to the forum.

Try something like this...

=0+DATEDIF(DATEVALUE("Jan 1, 2013"),TODAY(),"y")

Zero is the starting value if any
"Jan 1, 2013" is the "set" date

Substitute your start values and set date to suit. The formula, as it stands, should return a value of two

Hi and welcome to the forum.

Try something like this...

=0+DATEDIF(DATEVALUE("Jan 1, 2013"),TODAY(),"y")

Zero is the starting value if any
"Jan 1, 2013" is the "set" date

Substitute your start values and set date to suit. The formula, as it stands, should return a value of two

That worked! Thanks AlphaFrog. May I ratch it up a notch and ask if it's possible to include a 'start date' ie.

John Smith started work on 1 apr 2014 on salary point 40. he has a 9 month probation period which means he is not due an increment on 1 August 2014 but 1 August 2015 instead. How could this be incorporated in the above formula if, indeed, it can!

That worked! Thanks AlphaFrog. May I ratch it up a notch and ask if it's possible to include a 'start date' ie.

John Smith started work on 1 apr 2014 on salary point 40. he has a 9 month probation period which means he is not due an increment on 1 August 2014 but 1 August 2015 instead. How could this be incorporated in the above formula if, indeed, it can!

You're welcome.

I don't follow the reasoning of how 1 apr 2014 becomes 1 August 2015 (16 months), but I think you asking to add a fixed amount to the "set" date. The EDATE function can be used to add\subtract n months to a date.

Replies
10
Views
512
Replies
3
Views
159
Replies
5
Views
350
Replies
5
Views
294
Replies
1
Views
191

1,196,055
Messages
6,013,130
Members
441,750
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back