Auto create date for full month

[nagovind]

Dears,
Say for example in Cell A1, after entering the 1st day of the month as 01-05-2021, I need to get
A2 to A31 full month date of the particular month. i.e auto calculating the date for the date in the cell A1
Instead of dragging/ autofill, need to get the automated date.
Kindly advise
Regards
Govind

01 05 2021​

02 05 2021​

03 05 2021​

04 05 2021​

05 05 2021​

06 05 2021​

07 05 2021​

08 05 2021​

09 05 2021​

10 05 2021​

11 05 2021​

12 05 2021​

13 05 2021​

14 05 2021​

 

[Belleke]

Like this?

 

[Peter Bartholomew]

This can be achieved reasonably elegantly using Excel 365 but which is not really in the spirit of traditional Excel which assumes user interaction.

 

[GraH - Guido]

or old school
[B2]=IF(OR(A1="",A1=EOMONTH($A$1,0)),"",A1+1)
or alternative with dynamic array
[B2]=SEQUENCE(1,DAY(EOMONTH(A1,0))-1,A1+1,1)

 

[nagovind]

Like this?

Your reply is Exactly matching with my need
thanks a lot

 

[nagovind]

Dear Belleke ,
Kindly advise is it possible to make a below row to display ONLY the date without MONTH and YEAR
as 01 02 03 ......31
Regards
Govind

 

[nagovind]

GOT it by formatting the date as dd alone

Thanks a lot

 

[nagovind]

or old school
[B2]=IF(OR(A1="",A1=EOMONTH($A$1,0)),"",A1+1)
or alternative with dynamic array
[B2]=SEQUENCE(1,DAY(EOMONTH(A1,0))-1,A1+1,1)

Perfectly working as well
Thanks