Skipping weekends during a count

J

justaj

Joined
Aug 10, 2011
Messages
2
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate current time + 7 hours and skipping weekends 3
Skip weekends 1
Count Week Of Month 4
Date/Time Difference Excluding Weekends & Holidays 2
Total hours with NETWORKDAYS 2
Formula to make Excel count business days/skip weekends? 1
Subtracting time in date format 1
Deriving Exactly XXX Amount of Weekdays 3

Top