Auto update the date range

[mwvirk]

I am to enter the date from A1 to A31 like

01-Sep-2024
02-Sep-2024
-
-
-
Till end of the month
30-Sep-2024

I don't want to enter the full date format

I want to have a cell B1 where is put number 1 to 12 and in B2 input year e.g. 2024 and based on this, it should update the calendar

For example if value in B1 is 1 and B2 is 2024 then calendar should be updated like:

01-Jan-2024
02-Jan-2024
-
-
-
Till end of the month
31-Jan-2024

And if the value in B1 is 2 and B2 is 2024 then calendar should be updated like:

01-Feb-2024
02-Feb-2024
-
-
-
Till end of the month
28-Feb-2024

I hope it was explained properly and it can be done.

Thank you

 

[mwvirk]

1 more question.
It is possible if enter some value in a cell and it automatically calculate some specific % and return the result only
For example if I enter a value 100 but it should convert 50% and only show 50
If I enter 200 then it should convert 50% and show only 100

 

[kvsrinivasamurthy]

In A1 copied down up to A31.

=IF(MONTH(DATE($B$2,$B$1,1)+ROWS($A$1:$A1)-1)=$B$1,DATE($B$2,$B$1,1)+ROWS($A$1:$A1)-1,"")

 

[kvsrinivasamurthy]

D1=100
In D2

=50%*D1