Calculate days help

K

Kim K

I am needing to calculate dates. What I need to accomplish, is according to
a school calendar, which has weekends, holidays and other specified dates off
from school, what would be say the 50 day from today excluding the weekends,
holidays and spring breaks?

Can networkdays or other options within excel help me out?
 
F

Fred Smith

You want:
=workday(a1,50,c1:c20)

Where a1 is your start date, and c1:c20 are your list of holidays and days
off

Regards,
Fred
 

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 workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
Date Calculation problem 3
Calculate minutes between dates based on 9hr work days 1
Calculate the Days 8
Calculate work days 3
Re: How can I count the number of SATURDAYS in a month? 0
Help with a formmula change in a "flag" parameter! 19

Top