Hi Everyone,
I am looking at creating a roster with a month to a worksheet and say starting from A3 list each day for the month down the A column, which is easy.
What l am having trouble with is creating a formula that will list each day in each row of the A column (for example January would have from A3 to A34 with each day) but also having the name of each day in each cell as well.
Not sure how to attach a sample so l will try and create it here
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Tuesday
01/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Wednesday
02/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hope the example helps explain what l am trying to do.
I had tried using this =TEXT(YEAR(TODAY()),"dddd dd-mm-yyyy") but wouldn't give me the correct date or populate down the worksheet.
Would l need to use VBA to do it???
I am looking at creating a roster with a month to a worksheet and say starting from A3 list each day for the month down the A column, which is easy.
What l am having trouble with is creating a formula that will list each day in each row of the A column (for example January would have from A3 to A34 with each day) but also having the name of each day in each cell as well.
Not sure how to attach a sample so l will try and create it here
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Tuesday
01/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Wednesday
02/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hope the example helps explain what l am trying to do.
I had tried using this =TEXT(YEAR(TODAY()),"dddd dd-mm-yyyy") but wouldn't give me the correct date or populate down the worksheet.
Would l need to use VBA to do it???
Last edited: