Dates in excel

Copper Contributor


when the received date is after 03PM, is there a formula to consider received date to be the next day

for example, received date is 12/12/2023 15:05 PM the SLA is counted from the next working day which should start 12/13/2023 08:00 AM





1 Reply

@AlaaElHussieny There are a number of ways to accomplish this. Here's one possibility...


=IF(A2-INT(A2)>15/24, INT(A2)+32/24, A2)


...where A2 is the Received Date (see image below).


Adjusted Date/TimeAdjusted Date/Time