Hi everyone,
I'm working on a spreadsheet where I'm trying to figure out the date that a project will end. Basically I start with today's date and add another field (which calculates approximately how many more days will be required based off of current trends.)
So 8/10/11 + 3.8 days correctly gives me a response of 8/13/11. However the 13th is a Saturday. So my dilemma is trying to figure out how to make it skip the weekend and return a value of 8/15/11. (Monday)
I've been playing with NETWORKDAYS but so far I haven't had any luck. Ideas?
I'm working on a spreadsheet where I'm trying to figure out the date that a project will end. Basically I start with today's date and add another field (which calculates approximately how many more days will be required based off of current trends.)
So 8/10/11 + 3.8 days correctly gives me a response of 8/13/11. However the 13th is a Saturday. So my dilemma is trying to figure out how to make it skip the weekend and return a value of 8/15/11. (Monday)
I've been playing with NETWORKDAYS but so far I haven't had any luck. Ideas?