Find date from a cell

[Zalid]

I want to find the date in a cell that is above current cell. But the cell above current cell could be any number of cells above. It’s so I can auto-populate the current cell with the next day.
So:
A1 05/05/2023
A2
A3
A4 FUNCTION HERE TO PRODUCE 06/05/2023
A5
A6 FUNCTION HERE TO PRODUCE 07/05/2023

TIA,
ZTB

[JohnSUN]

Welcome back!
As one of many possible solutions.
Press CTRL+F3 and add a named formula

SUMPRODUCT(MAX(IF(OFFSET(A$1;0;0;ROW()-1;1)<>"";OFFSET(A$1;0;0;ROW()-1;1);"")))+1

Now in the next desired cell, enter =NextDate and get the result.

[Zalid]

@JohnSUN

SUMPRODUCT(MAX(IF(OFFSET(A$1;0;0;ROW()-1;1)<>"";OFFSET(A$1;0;0;ROW()-1;1);"")))+1

Well that works. Thank you