Return next value in row

[maym]

Hi

I have a list of dates as follows:

1/1/2017
2/1/2017
4/1/2017
17/4/2017
etc.

I am trying to write a formula that will return the date in the row below, see example attached?

[shukla.ankur281190]

Try

B2

Please Login or Register  to view this content.

[JohnTopley]

Based on your example


=IF(A3<>"",A3,A2)

[maym]

thanks very much to you both