sandero1970
New Member
- Joined
- Aug 23, 2013
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
Hi,
I'm trying to find a way to insert columns based on the weekday value of a date in the field.
All the dates of the month from 1 to 28 or 30 or 31 are located on line 2 as from column 2.
I need to make "a weekly planning" from Monday to Sunday but I have to shift the first day of the month in the correct column
For example 1/apr/2021 is a Thursday. When data is extracted from the source, the date is located in cell B2 and the weekday value (4) is located in cell B1.
Thursday being day 4, I need to insert 3 columns after column 1 so that 1st of April 21 comes in column 5.
Of course the number of inserted columns depends on the weekday of the 1st of the month
if 2 then 1 col
if 3 then 2 col
if 4 then 3 col
...
If 7 then 6 col
After that I will transform this in a Weekly planning from Mo to Su and will copy each block down the previous one so that I have very week each down the previous one.
Thx for your help.
I'm trying to find a way to insert columns based on the weekday value of a date in the field.
All the dates of the month from 1 to 28 or 30 or 31 are located on line 2 as from column 2.
I need to make "a weekly planning" from Monday to Sunday but I have to shift the first day of the month in the correct column
For example 1/apr/2021 is a Thursday. When data is extracted from the source, the date is located in cell B2 and the weekday value (4) is located in cell B1.
Thursday being day 4, I need to insert 3 columns after column 1 so that 1st of April 21 comes in column 5.
Of course the number of inserted columns depends on the weekday of the 1st of the month
if 2 then 1 col
if 3 then 2 col
if 4 then 3 col
...
If 7 then 6 col
After that I will transform this in a Weekly planning from Mo to Su and will copy each block down the previous one so that I have very week each down the previous one.
Thx for your help.