Forum Discussion

AlaaElHussieny's avatar
AlaaElHussieny
Copper Contributor
Dec 28, 2023

Dates in excel

Hello, 

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

 

 

 

excel

1 Reply

Sort By
  • djclements's avatar
    djclements
    Bronze Contributor
    Dec 28, 2023

    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/Time

Resources