Or maybe
Formula: copy to clipboard
=LET(u,SORT(UNIQUE(Date),,-1),IFERROR(INDEX(SORT(u),SEQUENCE(ROWS(u)+1)),INDEX(u,1)))