Working days

[Huwbob]

Hi. I can't use the functionality of the Add in, is there a way to calculate the number of working days between two given dates?

[Ron Coderre]

Try this:

A1: StartDate
B1: EndDate

This formula returns the numberof weekdays between those 2 dates (inclusive):
C1: =SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))

Does that help?

[Huwbob]

Thanks for that. I assume it counts in the dates given as well so to get a "five working day apart from the day request was taken" I simply put a -1 in at
=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1-1)/7))

It works, and gives me the correct answer, but there's a little green triangle on the top left of the box which gives an "inconsistent formula message", is it ok to just mark it as ignore?

[Ron Coderre]

Regarding the green triange....That's just Excel "helping" by letting you know that the formula is different from the formulas around it. In this case, it's OK to ignore.

To see other things Excel wants to help with...
<tools><options><error checking tab>
UNcheck anything you're not interested in knowing.

If you only want Excel to Error Check on-demand..
UNcheck: Enable background error checking

Then...when you want to check for "errors"
<tools><error checking>

I hope that helps.

[Huwbob]

Thanks for all your help