I need help in generating dates in column C to AG in sheet Attendance-Jan 23
based on the month and year in A2 of sheet config
I need help in generating dates in column C to AG in sheet Attendance-Jan 23
based on the month and year in A2 of sheet config
Please try in C1 and confirm formula with CTR+SHIFT+ENTER:Formula:Please Login or Register to view this content.
I need the entire range from C to AG to be filled I do not want to copy it cell by cell
is this too much effort? =Config!A2 in C1 of Attendance worksheet. Then this in D1 =C1+1, then grab the lower corner and drag right to AC1.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
is that what you want?
Power Query
it will auto fill whole month-row
if you want change source date then Refresh green table
Last edited by sandy666; 01-01-2023 at 03:43 PM.
Formula from the 29th day of the monthPlease Login or Register to view this content.
I need the entire range from C to AG to be filled I do not want to copy it cell by cell
The formula in post #2 returns the entire range from C to AG at once and you don't need to copy it cell by cell.
Please check the solution of post #2 again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks