Formula Help!!!

Rebecca Wilhelm

I can't get this formula to work. Any glaring mistakes?

 

=IF([Date Received at Settlement Desk]1) = "", "", IF([Date of Payment]1 = "", NETWORKDAY([Date Received at Settlement Desk]1, TODAY()), NETWORKDAY([Date Received at Settlement Desk]1, [Date of Payment]1)))

 

Thanks!

Mike Wilday

Are you receiving a particular error?

Mike Wilday

Actually, you were closing the first IF statement which was creating your error. Try this formula.

=IF([Date Received at Settlement Desk]1 = "", "", IF([Date of Payment]1 = "", NETWORKDAY([Date Received at Settlement Desk]1, TODAY()), NETWORKDAY([Date Received at Settlement Desk]1, [Date of Payment]1)))

Paul Newcome

You have an extra closing parenthesis after your very first cell reference. Try removing that and see if it works for you.

Rebecca Wilhelm

THANK YOU!

Mike Wilday

You're welcome! Glad I could help you out.