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