+ Reply to Thread
Results 1 to 2 of 2

Start Date and End Date Condition Checking Data Validation Drop Down List

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    Chennai,TamilNadu,India
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    61

    Start Date and End Date Condition Checking Data Validation Drop Down List

    I have 2 drop down cells, 1 for start date and 1 for end date. How do I lock the cells so that start date < end date and end date > start date ? I am successful in doing this for generic cells, but unable to do for the drop down cells in date format.

    Would be glad for your revert.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Start Date and End Date Condition Checking Data Validation Drop Down List

    I would think possibly setting the drop down validation list to only list the dates that are acceptable would be the way to go.

    Something like the attached, using a secondary list of dates as the actual DV list, should get you thinking.
    Attached Files Attached Files

+ 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. Getting Drop Down to Start at Top of List with Indirect using Data Validation
    By MayBTheresHope in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2016, 04:07 PM
  2. Checking if date value in cell is between or equal to start and end date
    By Beckmonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2014, 02:20 PM
  3. [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
  4. Drop Down List (Data Validation) Need to start at current value in list
    By bigmantitus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2014, 11:14 AM
  5. Macro: Automatic copy data from another sheet with condition checking date
    By SDCh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 12:58 AM
  6. Replies: 4
    Last Post: 05-17-2012, 04:40 PM
  7. [SOLVED] How to make drop-down list of dates start with current date?
    By Jan Buckley in forum Excel General
    Replies: 15
    Last Post: 08-29-2005, 05:05 PM

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