Hi guys,
I'm trying to change the formulae of my gannt chart date columns so that instead of giving the month number, it shows the week number instead.
Currently im using a DATE MONTH calculation to do this which I have then modified to give the month number by +1.
What I want to see instead is a similar view where the month is broken down into its constituent weeks with the correct week number attached.
This means the array of Years, Months will need to change.
Currently, the Year and the Month is calculated using the following;
=DATE(YEAR($B$1),MONTH($B$1),1)
Note: B1 = TODAY() and the Month and Year are formatted with a Custom format that only shows as 'mm' and 'yyyy'
The result is show in the below screenshot;
As mentioned earlier, I want to see this but looking only at the week numbers below the array of years.
Can anyone give me a hand with this?
Kind regards,
Jeevz
I'm trying to change the formulae of my gannt chart date columns so that instead of giving the month number, it shows the week number instead.
Currently im using a DATE MONTH calculation to do this which I have then modified to give the month number by +1.
What I want to see instead is a similar view where the month is broken down into its constituent weeks with the correct week number attached.
This means the array of Years, Months will need to change.
Currently, the Year and the Month is calculated using the following;
=DATE(YEAR($B$1),MONTH($B$1),1)
Note: B1 = TODAY() and the Month and Year are formatted with a Custom format that only shows as 'mm' and 'yyyy'
The result is show in the below screenshot;
As mentioned earlier, I want to see this but looking only at the week numbers below the array of years.
Can anyone give me a hand with this?
Kind regards,
Jeevz
