+ Reply to Thread
Results 1 to 2 of 2

Data Validation dates

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    1

    Data Validation dates

    I have two columns. First column is a date second column is a date. Second column can not be a date previous to first column. How would I use custom data validation to ensure an incorrect date is not entered in the second column?
    Last edited by Kylestum0527; 04-09-2020 at 06:21 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,729

    Re: Data Validation dates

    use a validation
    =B1>A1
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Data validation UK dates
    By starlev in forum Excel General
    Replies: 4
    Last Post: 11-06-2017, 03:14 PM
  2. Assistance with data validation for dates
    By trudiok in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-01-2017, 01:21 AM
  3. Data validation and dates
    By jtheule in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2016, 04:08 PM
  4. 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
  5. 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
  6. Data validation with dates
    By kadams99 in forum Excel General
    Replies: 1
    Last Post: 12-20-2010, 09:37 PM
  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