Formula Help IF(WEEKDAY(TODAY())=2,40,0)

[zone709]

=2840+IF(WEEKDAY(TODAY())=2,40,0)
I started last week at 2840 count right. When i check sheet yesterday it did add the 40 and made my count 2880. Today it went back to 2840.
What am I missing? I need it to add 40 every Monday and keep it that way going up thanks.

 

[jorismoerings]

Hi,

the part WEEKDAY(TODAY())=2 can only point to 1 day in the week. If think you mean to add 40 Hrs when WEEKDAY(TODAY())>=2

 

[zone709]

Yes trying to add 40 on every Monday to the original number 2840. How would i do this?

 

[jorismoerings]

Yes trying to add 40 on every Monday to the original number 2840. How would i do this?

=2840+IF(WEEKDAY(TODAY())>=2,40,0)

 

[zone709]

ok i see missing the > thank you

 

[zone709]

Hi so this Monday came again and the total number didn't go up another 40. I must be missing something. =2840+IF(WEEKDAY(TODAY())>=2,40,0)
I am just trying to have the total go up every Monday. 2840 then 2880 then 2920 etcc. When i opened sheet today the number stayed the same from last week.

 

[zone709]

Hi can anyone help me on this?

 

[Fluff]

How about

=2840+NETWORKDAYS.INTL(DATE(2023,11,27),TODAY(),"0111111")*40

 

[zone709]

How about

=2840+NETWORKDAYS.INTL(DATE(2023,11,27),TODAY(),"0111111")*40

Thanks for the reply. I will try this.

 

[Fluff]

You're welcome.