Forum Discussion
Trouble quoting date+time(hour/mins) of project start date/completion using the WORKDAY function.
Hello, I'm currently tasked with completing an excel document that accurately quotes job start and completion dates (including time of day within a work shift). So far I've been able to come up wit...
Deleted ,
Perhaps something like
=IF($I2="","", INT(WORKDAY($I2,$E2)+MOD($I2,1)+MOD($E2,1))+ MEDIAN(MOD(WORKDAY($I2,$E2)+MOD($I2,1)+MOD($E2,1),1),7.5/24,15.5/24) )
in attached file for Completion Date (1W) column
This worked almost perfectly! Thanks for the very quick response.
It seems to be calculating Saturdays and Sundays though.
Any ideas on how to remedy this and keep it to strictly Mon - Friday?
Document attached has the formula suggested integrated in columns 1w and 2w.