Huh ?
Presuming your dates are in Col A ... in A2 enter the current date.
In A3 paste this formula :Then drag that down the column as far as needed.Code:=IF(B2="","",IF(B2=(--"23:00"),A2+1,A2))
Presuming your dates are in Col A ... in A2 enter the current date.
In A3 paste this formula :Then drag that down the column as far as needed.Code:=IF(B2="","",IF(B2=(--"23:00"),A2+1,A2))
thanks!Look at the attached ...