+ Reply to Thread
Results 1 to 5 of 5

Data validation (list), confusion.

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    Bogotá. Colombia
    MS-Off Ver
    2013
    Posts
    14

    Data validation (list), confusion.

    Hello cordial greetings

    I am a bit confused, I need to perform a data validation in cell C7, so that the days correspond to the month set in cell C6 and the year found in cell C8. The data is recorded in the DATA tab; I have tried INDEX + MATCH functions, as well as OFFSET, but none of them meet what I require (I think I am making a lot of mistakes). Can you please help me with a solution or give me a hint on how to find a formula that does what is required.

    Exactly, what I am trying to do is that when selecting for example the month of January (C6) of the year 2018 (C8), in the drop-down list of the cell C7 only the 31 days corresponding to the specified month appear. That is to say, if I select February, 28 days will appear and not 30 or 31 days, with the exception of if it is a leap year, in which case, 29 days should appear for the month of February.

    To do this, I want to select the data corresponding to Year (A5:A45388), Name (C5:C45388) and Day (D5:D45388), which are located in the "Data" tab, and depending on the year selected in the Sheet 1 tab (C8) and month (C6), bring me the respective days for that date.

    Since January, March, May, July, August, October and December have 31 days, if I select any of these months, regardless of the year, those 31 days should appear in the drop-down list located in cell C7, and not 30 or 28 days.

    The same would apply if you select the months of April, June, September and November, in which case the 30 days should appear in the drop-down list in cell C7 and not 31 or 28 (29 if February is part of a leap year).

    Weather_1.png

    Weather_2.png

    Thank you very much for your valuable attention.

    PS: I have assigned range names to the table found in the DATA tab from the values in the top row (column header) and I am using Excel 365.
    Attached Files Attached Files
    Last edited by ferfer20; 08-05-2021 at 05:40 PM. Reason: SOLVED

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Data validation (list), confusion.

    Some contributors are reluctant (or not allowed to due to company policy) to download files from external sites. Try zipping your file and then attaching it here.


    Pete

  3. #3
    Registered User
    Join Date
    02-10-2021
    Location
    Bogotá. Colombia
    MS-Off Ver
    2013
    Posts
    14

    Re: Data validation (list), confusion.

    Sorry, I edit the post and attach again the file as binary book.

  4. #4
    Forum Contributor
    Join Date
    06-30-2015
    Location
    Netherlands
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    145

    Re: Data validation (list), confusion.

    HtH,

    Joris

    --------------------------------------------------------------------------------
    If you found my answer helpful, please hit the Like or Thank button.

    Please follow the forum Rules and Guidelines and use Code tags around your VBA code.

    Remember: test VBA code always on a copy of your file because usually you can't use undo

  5. #5
    Registered User
    Join Date
    02-10-2021
    Location
    Bogotá. Colombia
    MS-Off Ver
    2013
    Posts
    14

    Re: Data validation (list), confusion.

    Dear @joris moerings, thank you very much for your valuable information, it has solved my doubts. a huge hug!

+ 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. [SOLVED] VBA to Prevent Data Entry in Cell with Data Validation List - Two Criteria Validation
    By AliGW in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 05-25-2019, 11:48 AM
  2. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  3. Replies: 3
    Last Post: 06-04-2015, 02:27 PM
  4. [SOLVED] Data Validation: How to clear/delete the content of the cell and not Data Validation List?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2015, 09:42 AM
  5. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  6. Replies: 3
    Last Post: 04-11-2011, 05:52 PM
  7. [SOLVED] Validation Confusion-Excel 2003
    By Shirley Zaknich in forum Excel General
    Replies: 2
    Last Post: 08-16-2005, 09: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