Calculating days excluding weekends

Try using the NETWORKDAYS function.
Example:
A2: (a date)

This formula returns the number of workdays between that date and today:

Please Login or Register  to view this content.

See Excel help for coverage on how to exclude holidays when calculating the net work days.

Does that help?

Thanks Ron the formula does work however it's not showing what I want to see

What result are you expecting to see? Would be nice if you manually showed this in the workbook.

If you want to see the days elapsed between the start and finished dates then amend Rons formula to reference the relevant cells.

=NETWORKDAYS(A2,B2)

It would be handy for it to always use today's date.

So, how do you want to calculate the days elapsed? Per the start/finished dates or start date and today? The formula cannot accomodate both, but you can use two columns.

By the way, you have some Schedule Finish dates are earlier than the Schedule Start date, which will return negative values if the formula above is used.

I'm not sure I fully understand you question, but you seem to want know two things:

1. Number days elapsed since Schedule Start - finished date is open
2. Number of days elapsed between start and finish

If this is correct, then see attached. If this is not what you mean, mock up the workbook with the results you want to see and post it with a clearer explanation.

Great. Please mark your thread as solved and don't forget to add to the reputation of those who contributed a helpful response.