=if function with networkdays

I am attempting to write a formula where I can look at a date field and if it is blank have the formula calculate networkdays between two fields and if the date field is not blank then calculate the networkdays between a different two fields.

I have this as my formula:

=if([Order Approval Date]2 ="",NETWORKDAYS([OAM Date]2,[Contract Signature Date]1,ELSEif([Order Approval Date]2<1,networkdays([Order Approval Date]2,[Contract Signature Date]1))

Any help is most appreciated.

Find more posts tagged with

Project Management

Comments

Paul Newcome

=IF([Order Approval Date]2 = "", NETWORKDAYS([OAM Date]2, [Contract Signature Date]1), IF(ISDATE([Order Approval Date]2), NETWORKDAYS([Order Approval Date]2, [Contract Signature Date]1)))

Give this a try...

Sign in to join the conversation!

Quick Links

Trending discussions

Grid creation
Hi All, I have a sheet that I am creating to gather powder coat thickness data. The problem I have run into is that they can do up to 5 checks on the same line during the same day and shift. Then they get the average of those measurements to use for the day to determine if the thickness passed or failed. If I have a form…
APPROVAL SETTING VIA "ADVANCED OPTIONS" - APPROVAL WORKFLOW
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
Share Tab not activated
New to smart sheet pro and I desire to share to viewer, share tab not activated...how do I activate and share a sheet with a viewer?