# Change date in cell and row follows.

#### Gazbray24

##### New Member
Hi,

I have created the following formula - =IF(A2=31,\$A\$1+1,A2+1) - which creates a rolling date/number between 1 & 31. I want the rows to follow when the date changes i.e. change the first cell, A2 to 02/01/17, all cells will change but, i want B2 or the row, to follow that date.

Start is
B2 C2
A2 01/01/2017 Brian Coles
A3 02/01/2017 Bob Downie
A4 03/01/2017 Dave Smith

Change is

A2 02/01/2017 Bob Downie
A3 03/01/2017 Dave Smith

Kind regards,

Gary Bray.

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Your question is not really clear.
I have created the following formula - =IF(A2=31,\$A\$1+1,A2+1)
What cell is this formula in?

which creates a rolling date/number between 1 & 31
And how exactly are you using/incorporating this on your worksheet?

It appears that the spacing on your example got messed up, so it is hard to understand how your data is really line up. There are tools you can use to post screen images. They are listed in Section B of this link here: Guidelines for Forum Use. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Or, if you use Code tags around your data, it will maintain spacing. But note that you will have to play around with that a bit to get it to line up properly. In the Advanced Editor, you can use the "Preview Post" to see what the data will look like before posting it. So I just go back and forth with this until I have things looking nice and then post it.

Replies
1
Views
301
Replies
2
Views
142
Replies
6
Views
295
Replies
2
Views
525
Replies
2
Views
405

1,216,313
Messages
6,130,010
Members
449,550
Latest member
8073662045

### 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