I've used networkdays to calculate averages between 2 different dates while excluding weekend and holidays. I am currently trying to add a number of days to a date time stamp and have it properly reflect the added days and hours. To do this, I have been attempting to add 1.75 days to a date, such as 6/17/25 1:19 PM. I would expect this to result in 6/19/25 7:19 AM.
I attempted to use WORKDAY to accomplish this through =WORKDAY(A1,B1) where A1 is the date/time as shown above (6/17/25 1:19 PM) and B1 is the 1.75. This results in 6/18/25 12:00 AM. I'm definitely missing something here and would appreciate any help.
WORKDAY only deals with days not time. You will need to do the addition of time outside the WORKDAY:
=WORKDAY(INT(A1),INT(B1)) + MOD(A1,1) + MOD(B1,1)
But if the decimal addition would increase the integer you may need to do something like:
=WORKDAY(INT(A1),INT(B1)+INT(MOD(A1,1) + MOD(B1,1))) + MOD(A1,1) + MOD(B1,1) - INT(MOD(A1,1) + MOD(B1,1))