Lookup and Populate cell

[monkeyharris]

Hi,
In cell A2 i want the user to enter the month "January", ebruary" etc. Once this has been donei want the cells from A3 downwards to automaticly show the days in that month.

Any help please.

 

[steve the fish]

Put this in A3 and copy down 31 cells. You may need to change the year if it happens you need a leap year February. Is that what you mean?

=IFERROR(DAY(ROWS($A$1:A1)&LEFT($A$2,3)&2019),"")

May need a little alteration depending on local date setting.

 

[Scott T]

I assume you want to use the current year for the number of days in Feb since there are sometimes leap years.

Book1
	A
2	February
3	1
4	2
5	3
6	4
7	5
8	6
9	7
10	8
11	9
12	10
13	11
14	12
15	13
16	14
17	15
18	16
19	17
20	18
21	19
22	20
23	21
24	22
25	23
26	24
27	25
28	26
29	27
30	28
31
32
33
Sheet1

Cell Formulas
Range	Formula
A3	=IF(ROWS(A$3:A3)<=DAY(EOMONTH(DATEVALUE($A$2&" "&YEAR(TODAY())),0)),ROWS(A$3:A3),"")

 

[Fluff]

Or if you want the actual dates for the month
=IFERROR(DATE(YEAR(TODAY()),MONTH($A$2&1),DAY(ROW($A1)&$A$2&YEAR(TODAY()))),"")

 

[monkeyharris]

Or if you want the actual dates for the month
=IFERROR(DATE(YEAR(TODAY()),MONTH($A$2&1),DAY(ROW($A1)&$A$2&YEAR(TODAY()))),"")

Can't thank you all enough. The formula which keeps the days consistent with the month is fantastic.

 

[Fluff]

Glad we could help & thanks for the feedback