Increment a cell monthly on 28th

[kmsalehi]

I have a value (400) which was incremented manually till now on the 28th of each month. I would like excel to automatically increment it by adding 10 to the total 400 on 28th of each following month.

Thanks

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[Kirkules]

This was a bit tricky for me.

Please Login or Register  to view this content.

If you want the +10 to start next month, change 400 to 390

[bebo021999]

In case of counting how many 28th passed between specific date in A1 and today:

Please Login or Register  to view this content.

[kmsalehi]

That worked perfectly. Thanks