IF Then [Incorrect Argument] Question.

Mike B

Please assist with this formula:

=IF(Status@row, "Fully Approved", [Signing Status]@row, "Sent", NETDAYS([Fully Approved Date]@row + 1))

In this case the bold portion is my THEN calculation.

Amber Eakin

Thanks for the clarification, @Mike B . Give this one a go. Let me know if this works!

=IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY(), "")

Amber Eakin

OOPS! I forgot a parenthesis. Now try, @Mike B .

=IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY()), "")

Mike B

I also tried

=IF(AND(Status@row, "Fully Approved", [Signing Status]@row, "Sent",) NETDAYS([Fully Approved Date]@row + 1), "")

Amber Eakin

Hi @Mike B - What are you trying to make the formula do? I think there's an issue particularly with the NETDAYS. What are the dates you're trying to determine? If you're trying to see the NETDAYS between the "Fully Approved Date" and today+1, this should work.

=IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY(+1)), "")

Mike B

Hi Amber, If the two conditions are met, I wanted to calculate the number of days between Fully Approved Date and current date.

I received the error: UNPARSEABLE

Amber Eakin

Thanks for the clarification, @Mike B . Give this one a go. Let me know if this works!

=IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY(), "")

Mike B

The formula is meeting the conditions; however the result is #INCORRECT ARGUMENT set.

Amber Eakin

OOPS! I forgot a parenthesis. Now try, @Mike B .

=IF(AND(Status@row = "Fully Approved", [Signing Status]@row = "Sent"), NETDAYS([Fully Approved Date]@row, TODAY()), "")

Mike B

Perfect!!!!!! Thank you so much!!!