How to get two formulas in one cell

[sundodger]

Hi All, I currently have the formula =IF(A2=4,NETWORKDAYS(B3-6,E3,'Bank Holidays'!A2:A10))
In A2 is a formula counting how many Fridays are in a month. B3 has the Date of the First Friday and E3 the date of the 4th Friday.
what i would like to do is if A2=5 then the E3 would calculate on F3 instead if that Friday is in the same month as B3
Hope this makes sense

Thanks
Mark

 

[nikio8]

hi not super clear, you are missing part of If statement, FALSE, IF(condition, true, false)

=IF(A2=4,NETWORKDAYS(B3-6,E3,'Bank Holidays'!A2:A10))

=IF(A2=4,NETWORKDAYS(B3-6,E3,'Bank Holidays'!A2:A10), IF(A2=5,NETWORKDAYS(B3-6,F3,'Bank Holidays'!A2:A10) ) )

 

[sundodger]

That worked perfectly. Thank You

 

[Peter_SSs]

If A2 will always be either 4 or 5, you could shorten that up to

=NETWORKDAYS(B3-6,IF(A2=4,E3,F3),'Bank Holidays'!A2:A10)