I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

=if(A1B1+5,"Failed","Passed")

"Rachael F" wrote:

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

Thanks bj. What if I only want to count working days?

"bj" wrote:

=if(A1B1+5,"Failed","Passed")

"Rachael F" wrote:

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

Use the WORKDAY function in your If statement. It is in the Analysis
Toolpack addin if it isn't in your Excel already.

Hope that helps.

"Rachael F" wrote:

Thanks bj. What if I only want to count working days?

"bj" wrote:

=if(A1B1+5,"Failed","Passed")

"Rachael F" wrote:

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

=if(networKdays(B1,A1,holiday_range_if _wanted)5,"Failed","Passed")
you have to have the analysis toolpac added for this to work.
the holiday range is optional. Check help for more info.

"Rachael F" wrote:

Thanks bj. What if I only want to count working days?

"bj" wrote:

=if(A1B1+5,"Failed","Passed")

"Rachael F" wrote:

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

Thanks bj.

Leading on from my original question, how can the formula
'=if(networKdays(B1,A1,holiday_range_if _wanted)5,"Failed","Passed")' be
changed to incorporate the following:

if A1 is blank, base the calculation on C1 instead




"bj" wrote:

=if(networKdays(B1,A1,holiday_range_if _wanted)5,"Failed","Passed")
you have to have the analysis toolpac added for this to work.
the holiday range is optional. Check help for more info.

"Rachael F" wrote:

Thanks bj. What if I only want to count working days?

"bj" wrote:

=if(A1B1+5,"Failed","Passed")

"Rachael F" wrote:

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael

=if(A1="",if(networKdays(B1,C1,holiday_range_if
_wanted)5,"Failed","Passed"),if(networKdays(B1,A1 ,holiday_range_if
_wanted)5,"Failed","Passed"))

would be one option

"Rachael F" wrote:

Thanks bj.

Leading on from my original question, how can the formula
'=if(networKdays(B1,A1,holiday_range_if _wanted)5,"Failed","Passed")' be
changed to incorporate the following:

if A1 is blank, base the calculation on C1 instead




"bj" wrote:

=if(networKdays(B1,A1,holiday_range_if _wanted)5,"Failed","Passed")
you have to have the analysis toolpac added for this to work.
the holiday range is optional. Check help for more info.

"Rachael F" wrote:

Thanks bj. What if I only want to count working days?

"bj" wrote:

=if(A1B1+5,"Failed","Passed")

"Rachael F" wrote:

I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael