Maybe I'm going about this the wrong way? I'm taking a previous coworkers sheet and trying to modify and update and upgrade it to meet my needs. The sheet itself is a little more involved but I did a sample to share. Basically this is somewhat of a construction schedule and I'm trying to list an expected and an actual date for several deliverables and try to run out and calculate the schedule based on either the expected date or, if there is an actual date, that date. The formulas I have and modified work fine..... but I'm trying to calculate these on WORKING days and not just CALENDAR days. Maybe I'm trying to combine too many functions and it's not possible? Hopefully it is possible. I'm attaching the sheet for the gurus here to hopefully maybe help me out. I searched but only saw a varying combination of results none of which combined everything that I think I'm trying to do here.
Bookmarks