Excel 2010 Formula that uses IF, AND & OR Functions

[jakecutler]

Hi,

Im not sure if this is even possible but need some help with a formula that uses IF, AND & OR Functions.

The formula is to help log and predict specific dates in a set process when certain 'hoops' of the process are jumped through.

The formula ive currently come up with and is invalid/has too many arguments is this:

=IF(K9="","",K9-WEEKDAY(K9,3),IF(AND(K9>=01/01/1986,N9="N/A"),K9-WEEKDAY(K9,3),"",OR(AND(K9>=01/01/1986,N9>=01/01/1986),N9-WEEKDAY(N9,3)))

Other versions that also dont work that i have attempted are these:

1.
IF(AND(K9="",N9=""),"",(K9-WEEKDAY(K9,3),IF(AND(K9=">01/01/1986",N9="N/A"),(K9-WEEKDAY(K9,3),"",IF(AND(K9=">01/01/1986",N9=">01/01/1986"),(N9-WEEKDAY(N9,3),"")))

2.
=IF(AND(K9="",N9=""),"",(K9-WEEKDAY(K9,3),IF(AND(K9>=01/01/1986,N9="N/A"),(K9-WEEKDAY(K9,3),""),IF(AND(K9>=01/01/1986,N9>=01/01/1986),(N9-WEEKDAY(N9,3),"")))

Any help would be very much appreciated as ive spent hours upon hours trying to figure it out!

Happy to upload a sample if required.

Thanks

Jake

[:) Sixthsense :)]

May be this..


=IF(K9="","",IF(AND(K9>=DATE(1986,1,1),N9="N/A"),K9-WEEKDAY(K9,3),IF(AND(DATE(1986,1,1),N9>=DATE(1986,1,1)),N9-WEEKDAY(N9,3),"")))

[jakecutler]

Hi Sixthsense

I think you got it....

I need to confirm

[jakecutler]

Hi Sixthsense

Yep you got it, thank you very much!

Please just ignore the sample file, didnt mean to post that.

Cheers

Jake