Fill all date of a month according to criteria

[HaroonSid]

hi,
i want to fill all dates of a month in range A4:A35

while Month = range("A2").value
and
Year = range("A3").value

for example
range a2 = april
range a3 = 2017

then range a4:a35 value =

01/05/2017 Monday
02/05/2017 Tuesday
03/05/2017 Wednesday
04/05/2017 Thursday
05/05/2017 Friday
06/05/2017 Saturday
07/05/2017 Sunday
08/05/2017 Monday
09/05/2017 Tuesday
10/05/2017 Wednesday
11/05/2017 Thursday
12/05/2017 Friday
13/05/2017 Saturday
14/05/2017 Sunday
15/05/2017 Monday
16/05/2017 Tuesday
17/05/2017 Wednesday
18/05/2017 Thursday
19/05/2017 Friday
20/05/2017 Saturday
21/05/2017 Sunday
22/05/2017 Monday
23/05/2017 Tuesday
24/05/2017 Wednesday
25/05/2017 Thursday
26/05/2017 Friday
27/05/2017 Saturday
28/05/2017 Sunday
29/05/2017 Monday
30/05/2017 Tuesday
31/05/2017 Wednesday

thank you in advance

[Sintek]

Surely you mean if A2 = may

[HaroonSid]

Yes

a2 = may

[Sintek]

This is the best I could come up with; Works if A2 = month No and not month name: Adapted from code found in Source: Stack overflow

Please Login or Register  to view this content.

[HaroonSid]

thank you
its working

[jindon]

hi,
i want to fill all dates of a month in range A4:A35

while Month = range("A2").value
and
Year = range("A3").value

Please Login or Register  to view this content.

[Sintek]

@ jindon

Flawless designer code as always. Do you feel like helping me with my code to allow for Month name and not Month No.

Works if A2 = month No and not month name

[Sintek]

thank you
its working

pleasure, Glad I could help. Thanks for rep point