+ Reply to Thread
Results 1 to 3 of 3

Data Validation - Need a date or specific text to be input

  1. #1
    Registered User
    Join Date
    04-25-2016
    Location
    Dublin
    MS-Off Ver
    2010
    Posts
    2

    Data Validation - Need a date or specific text to be input

    Hi there - Looking for some advice / Tips - I am currently creating a controls framework spreadsheet and there is one particular field that requires a Date or the text TBD

    I can do each of these as singular however I would like to be able to be able to only have these values input in the cell

    Hope this makes sense - Trying to avoid VBA but will revert if required

    Thanks very much

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Data Validation - Need a date or specific text to be input

    Use data validation- custom and as a formula use something like:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    so only text NA or any date from between Jan 1 prev year to Dec 31 next year will be allowed
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    04-25-2016
    Location
    Dublin
    MS-Off Ver
    2010
    Posts
    2

    Re: Data Validation - Need a date or specific text to be input

    Quote Originally Posted by Kaper View Post
    Use data validation- custom and as a formula use something like:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    so only text NA or any date from between Jan 1 prev year to Dec 31 next year will be allowed
    Perfect - thanks a million

+ 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: 7
    Last Post: 10-02-2017, 12:09 PM
  2. Format text in validation data input box
    By Atride in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-24-2014, 05:11 AM
  3. [SOLVED] Data validation based on another cell containing specific text
    By Sph01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2013, 05:51 AM
  4. [SOLVED] Data validation against a date: Specific Day of week
    By CzR852 in forum Excel General
    Replies: 8
    Last Post: 06-18-2013, 12:43 PM
  5. [SOLVED] Input date via use of input box with validation
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2013, 11:43 PM
  6. Data from Input Box overrides cell input validation
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-01-2007, 02:29 PM
  7. macro to input data on a specific date
    By Ray in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2006, 10:50 PM

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