Activity Schedule cell recognition question

[mgstilwell]

Good Morning,
E22 shows the number of employees needed for the activity.
H22 shows the number of workdays between the dates inputted at cells F22 and G22
N22 does not visually show as a workday which I am trying to figure what to change within the cell formula in order to fix this issue? (see attachment)

Many Thanks!

 

[Fluff]

The easiest way to find why a formulae is not giving the expected result is to use the "Evaluate formula" option on the formula tab. That way you can step through the calculation seeing what it gives.

In this case Weekday(n1,2) will give 6 for a Saturday, hence you get 0 as the output.

 

[mgstilwell]

The easiest way to find why a formulae is not giving the expected result is to use the "Evaluate formula" option on the formula tab. That way you can step through the calculation seeing what it gives.

In this case Weekday(n1,2) will give 6 for a Saturday, hence you get 0 as the output.

Thanks for the Tip, I had tried the evaluate formula with this question and cannot seem to get a definitive solution. Still cannot figure how to include Saturdays within the formula?

 

[Fluff]

Maybe, change <6 to <=6

 

[mgstilwell]

Maybe, change <6 to <=6

That Worked! Thanks fo being patient with my little knowledge. Good Day!

 

[Fluff]

Glad to help & thanks for the feedback