+ Reply to Thread
Results 1 to 3 of 3

Data Validation; Date OR N/A

  1. #1
    Registered User
    Join Date
    10-19-2022
    Location
    Wisconsin, US
    MS-Off Ver
    365
    Posts
    7

    Data Validation; Date OR N/A

    Working on a table, can you do data validation for a date OR n/a? For example, I have certification expiration dates, some expire 3 years after distribution, some never expire. Thanks in advance!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,659

    Re: Data Validation; Date OR N/A

    Not completely clear (to me) what you want the data validation to check. Please elaborate.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    10-19-2022
    Location
    Wisconsin, US
    MS-Off Ver
    365
    Posts
    7

    Re: Data Validation; Date OR N/A

    Hey! Thanks for the response, apologies on the clarity.

    I have an excel table that will be filled out via a form. It will be used to track employee information and certifications. Many of the columns are "Expiration Date" in regards to certifications employees may or may not have. I am hoping to limit answers to a specific date, or "n/a" (not applicable). This is because I'm using conditional formatting to warn us when expirations are coming due. I don't want to leave blank, for many reasons. In data validation, I see that I can provide an error message if an entry is not a date, but I don't see a way to provide a "n/a" option as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-20-2017, 10:29 AM
  2. Replies: 5
    Last Post: 04-06-2016, 06:58 AM
  3. [SOLVED] Data Validation. Date Format in UserForm Data Entry
    By kmlloyd in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-09-2015, 11:12 PM
  4. [SOLVED] Data Validation: using date in as initial date in range
    By dmorl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-01-2015, 10:10 AM
  5. [SOLVED] Data Validation won't accept Start Date and End Date from cell values.
    By SpecialBrew in forum Excel General
    Replies: 12
    Last Post: 03-16-2014, 10:23 PM
  6. Adding Date Data Validation to cells with List Data Validation
    By biggtyme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 09:47 AM
  7. Trying to use a date data validation.
    By Stevie-B in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2008, 10:22 AM

Tags for this Thread

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