No Criteria For Due Date

[DonnyF]

Hello,

There was a request to add another criteria and I'm not sure how to handle it. There are some pieces that do not have a due date but instead will have "Cal Before Use". This formula works fine for Weekly, Monthly, Quarterly, or Yearly criteria. I get #N/A when putting "Cal Before Use" in H7.

Does anyone know how to allow for this?

Thank you,
Donny

Please Login or Register  to view this content.

[DonnyF]

After playing around with the formula this seems to work:

Please Login or Register  to view this content.

Maybe there are other ways not sure.

[DonnyF]

Hello again,

In addition to "Cal Before Use" there has been a request for "No Calibration Required" and "For Reference Only".

The formula is very long now and want to be able to add these other criteria which will not do any calculations but I would like to avoid having "#N/A" in the cells.

If someone knows how to edit the formula for these changes I would greatly appreciate it.

Donny

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[DonnyF]

I attached the file thank you for taking a look. The sheet in question is the Calibration Log.

[protonLeah]

Your sheets are passdword protected...

[DonnyF]

Your sheets are passdword protected...

Click unprotect on Switchboard sorry about that

[Phuocam]

Maybe?

=IFERROR(IF(K7="","",IF(H7="Weekly",G7+7,EDATE(G7,CHOOSE(MATCH(H7,{"Monthly","Quarterly","Yearly"},0),1,3,12)))),"")

[DonnyF]

Thank you it works great!