Results 1 to 6 of 6

Formula Assistance

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2008
    Location
    Rhode Island
    Posts
    56

    Question Formula Assistance

    Hello!

    I'm not sure how to fix this one. I need to put my formula to calculate working days opposed to calendar days.

    The formula that I'm using now is:

    =IF(OR(U8=0,U8=""),"",IF(U8="N/A","N/A",IF(OR(U8="Same Day",U8<=7),"Compliant","Non Compliant")))

    How could I change this to add working days?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1