+ Reply to Thread
Results 1 to 3 of 3

Data validation and dates

  1. #1
    Registered User
    Join Date
    08-27-2016
    Location
    San Diego
    MS-Off Ver
    2016
    Posts
    6

    Data validation and dates

    Hi all,
    This is my first post. I am trying to create a custom data validation for a spreadsheet that will do two things. First, I need it to require that the user fills in the cell above the current one so that lines are not skipped (for example I am using =LEN($J11)>0) to accomplish this). The second part is that I would like to make a data validation that would require the cell be a date. Not just the date formatting. I need to ensure that the users input an actual date. I realize that there is a data validation just for dates, but to my knowledge you cannot have two data validations in the same cell. I was thinking/hoping that there might be a way I can write a custom formula that would include both of these for validation. Any ideas? Please and Thank You

  2. #2
    Registered User
    Join Date
    08-18-2016
    Location
    Earth
    MS-Off Ver
    2010 and 2013
    Posts
    64

    Re: Data validation and dates

    Go to data validation > Allow: Custom > uncheck ignore blank

    then put in

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


    This will force them to have dates only. Works as long as the dates they input is after year 1900.
    01001000 01101001 00100001

  3. #3
    Registered User
    Join Date
    08-27-2016
    Location
    San Diego
    MS-Off Ver
    2016
    Posts
    6

    Re: Data validation and dates

    This seemed to do the trick. Thank you so much!!

+ 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. Dates according year in cell with data validation
    By Immortal2014 in forum Excel General
    Replies: 3
    Last Post: 08-02-2016, 06:58 AM
  2. [SOLVED] Data Validation formula for certain dates and text
    By kosherboy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-20-2014, 12:22 PM
  3. Help with data validation - problems with dates and times
    By tfgorman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-22-2013, 05:57 AM
  4. Data Validation VBA forcing US format dates
    By penfold in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2011, 09:40 AM
  5. Data validation with dates
    By kadams99 in forum Excel General
    Replies: 1
    Last Post: 12-20-2010, 09:37 PM
  6. Data Validation for dates & time exceeding 24hrs
    By Zyphon in forum Excel General
    Replies: 4
    Last Post: 08-30-2007, 04:37 AM
  7. [SOLVED] Dates using Data / Validation
    By susan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2006, 07:30 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