# Move to next day after 12 midnight

Huh ?

#### Logit

##### Active Member
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.

• akumaba024

#### Peter Bartholomew

##### Well-Known Member
Another take on the problem might be to accept any standard datetime but to report the work-date using the formula
= INT(datetime) + (MOD(datetime, 1) >= TIME(21,0,0))
where the green represents the date (with time information stripped out) and the green increments the reported date by one day for times later than 9pm.

#### akumaba024

##### New Member
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.

Hi .. this is what I got #### Logit

##### Active Member
Look at the attached ...

#### Attachments

• 27.5 KB Views: 3

You are welcome.