=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.
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.