Change date in cell and row follows.

Gazbray24

New Member
Joined
Dec 19, 2014
Messages
4
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.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,882
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,217
Messages
5,594,887
Members
413,947
Latest member
gizmolucy

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top