Print the days based on the month number

[Muneer_Alrashdan]

hello
I have an excel file containing the month number
I want to print the days depending on the month number as in the picture

(It starts by printing the days according to the day on which the month begins)

[Savan_S_Bangoria]

Hi @Muneer_Alrashdan,

you can try using the below code and put it in a loop where the date number will change.
So put the bolded part as a variable and change it using a loop it will give the weekday for each day of the month once you do that.

datetime.ParseExact(“01-feb-23”,“dd-MMM-yy”,System.Globalization.CultureInfo.InvariantCulture).DayOfWeek