+ Reply to Thread
Results 1 to 4 of 4

Automatic date display based on input cells month and year

  1. #1
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2016
    Posts
    219

    Automatic date display based on input cells month and year

    Hi,

    Is there a way, to have in A1 a list of months via data validation, in A2 you have a list of years, again by data validation, then what ever month / year you select, below it in A2 downwards, you get the list of all dates in that month.

    IE

    If A1 was selected as January and A2 was Selected as 2020

    A2 Would be 01/01/2020
    A3 Would be 02/01/2020
    A4 Would be 03/01/2020

    Thanks
    Last edited by Badvgood; 03-27-2020 at 04:52 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,049

    Re: Automatic date display based on input cells month and year

    Hi there,

    See if the attached workbook does what you need.

    The only cells of interest are C29, C30 and C31. Cell C29 contains the formula:

    Please Login or Register  to view this content.
    Cells C30 and C31 contain similar formulas, but use offsets of two and three respectively.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2016
    Posts
    219

    Re: Automatic date display based on input cells month and year

    Quote Originally Posted by Greg M View Post
    Hi there,

    See if the attached workbook does what you need.

    The only cells of interest are C29, C30 and C31. Cell C29 contains the formula:

    Please Login or Register  to view this content.
    Cells C30 and C31 contain similar formulas, but use offsets of two and three respectively.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Perfect, thank you so much. Stay safe during Corona.

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,049

    Re: Automatic date display based on input cells month and year

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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