Hello,

I am trying to make a formula that looks at a date and works out if it came in at a certain time to get a due date.

IF the item comes in on 1 day between 08:00 and 18:00 the job has 8 days to complete.

IF the item comes in between 18:00 the day before and 08:00 on that day they have 8 days up to 18:00 from that day to complete.

I cant work out how to get the formula to work out the day before and add 8 days from the next day.

05/04/2021 09:56:00 This one would have 8 days to complete up to 18:00 on the 13/04/21

25/03/2021 02:00:00 this one would have 8 days to complete up to 18:00 on the 21/04/21

25/03/2021 19:21:00 This one would have 8 days to complete up to 18:00 on the 22/04/21

Thanks for the help.