I want it to write days of the current month in a single row, column by column. Exactly like in the sample. if you look at the sample excel I shared you will understand better
here are the column A.---------B.--------C.----D.----E----.F…
and this is ,1st row 2/1/2020–2/2/2020–2/3/2020
Date format is (M/d/yyyy)
I hope I made it more clear to understand
So actually I want to make a datatable with headers as date.
okay I understand but I dont want to write day by day. So when its begining of month this will execute and fill all the headers with days of current month.