List of Days

[annadinesh]

Dear Experts

Kindly Provide a formula to get list of dates for the month from Cell A4 to autofill to last date of the month.

and another formula for
list of Weekdays fo the month


Regards


Dinesh Saha

 

[kvsrinivasamurthy]

Month number is in A2.
In A4 copy down up to A35.

=IF(ROW()=4,DATE(2025,$A$2,1),IF($A3<>"",IF(MONTH($A3)=MONTH($A3+1),$A3+1,""),""))