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

Calculating days spent to complete a task 2
Calculate workdays for irregular work patterns 1
Date Calculation problem 3
How to calculate the number of Workdays for irregular work pattern 1
Calculate minutes between dates based on 9hr work days 1
Help with a formmula change in a "flag" parameter! 19
How do I calculate difference in days & hours between two dates e. 1
Date Calculation question 3

Top