Does anyone know how to simplify this for me 🙂
What I need to do is to check for every week number in the year. (1 to 53)
if(week(CS_MUST_start_FuldDato)<= 8,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=8,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 9,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=9,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 10,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=10,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 11,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=11,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 12,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=12,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 13,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=13,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 14,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=14,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 15,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=15,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 16,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=16,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 17,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=17,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
-
if(week(CS_MUST_start_FuldDato)<= 18,
if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=18,
(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))
),0)
ETC.
.
.
.
.
.........
