Automatic date display based on input cells month and year

**Badvgood** · 03-26-2020, 04:14 PM

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

**Greg M** · 03-26-2020, 07:49 PM

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

**Badvgood** · 03-27-2020, 04:51 AM

Originally Posted by Greg M

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.

**Greg M** · 03-27-2020, 04:44 PM

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

Automatic date display based on input cells month and year

LinkBack

Thread Tools

Rate This Thread

Display

Automatic date display based on input cells month and year

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Display the first of the following month based on a date in previous cells

[SOLVED] Extract Day, Month and Year from a text box (user input) date value

Macro or Formula to create Date range by getting input of month and year

[SOLVED] Display the first date of the month when the month and year are selected

[SOLVED] How do I display the date when a year and month are selected

[SOLVED] Function to Display Input Box, Retrieve Date, and Return Day, Month And Year

Change Date to display Month/Year

Bookmarks

Bookmarks

Posting Permissions