Rounding up Date w/ military time to next day if 12:00 or greater

[jacksonjeff25]

The goal is to calculate the number of working days (excludes weekends and holidays) between a submit date and due date. The submit date includes the time of the day. Where i need help...I want to round up to the next day for items submitted after 12:00 PM (12:01 - 23:69). Ideally, I would want it to round to the next working day (example: Friday, January 1, 2021, 21:00 would round to Monday, 1/11/2021), but I will settle for next day. My company blocked me uploading an actual example of the sheet, but I did upload a picture that includes the formulas.

Data columns: Column A is the "submit date" that includes the time. Column C is due date.

Columns with calculations:
- Column B is my attempted to round up to the next day if the submit time was in the PM. I used "ROUNDUP" formula, which worked 4 out of the 11 submit dates that should have been round up. (Red outline box indicated correct rounding. Yellow fill indicates date that should have been rounded to next day.
This is the formula where I need help. My round up formula is inadequate. =ROUNDUP(RawData[@[Submitted Date]],1)

- Column D calculates the working days (excluding weekends & using a reference list of holidays to exclude). This calculation seems to work correctly.
=NETWORKDAYS(RawData[@[Clean Submit Date]],RawData[@[Clean Client Meeting Date]],Reference!$G$3:$G$31)

 

[Dave Patton]

Date and Time 2021.xlsm
	A	B	C	D	E
1				Due Date	Working Days
2	08-Jan-21 12:30			12-Jan-21	2
3	08-Jan-21 09:30			12-Jan-21	3
4
3b

Cell Formulas
Range	Formula
E2:E3	E2	=NETWORKDAYS(ROUND(A2,0),D2,Holidays)

Named Ranges
Name	Refers To	Cells
Holidays	='3b'!$J$2:$J$8	E2:E3