#### sandero1970

##### New Member

- Joined
- Aug 23, 2013

- Messages
- 8

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.