Variables as week No

[fabricius]

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.

.

.

.

.

.........