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