SOLVED

excel formulas

Copper Contributor

I am trying to create a sheet that will view the dates and milestones of different classes.  Is there a way to designate the training days and specify to exclude holidays and weekends from the start and end dates?  I have a class that is 9 days, and depending on the weekends and holidays it actually covers 13-14.  On certain training days, there are milestone events, but when I just add the training day number of the event to the start date, it doesn't line up properly. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Kupka8

Here's a link to an excellent website that gives practical advice on various topics. From what I read, the WORDAY.INTL function may be just what you need. But you'll see that this site offers ways to explore the many other functions Excel has for days.

Thank you!!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Kupka8

Here's a link to an excellent website that gives practical advice on various topics. From what I read, the WORDAY.INTL function may be just what you need. But you'll see that this site offers ways to explore the many other functions Excel has for days.

View solution in original post