Formula ? Change number on every Tuesday of the week

[zone709]

Hi I need to add 500 to the last number every week. As for now I been doing it sometimes and then sometimes I forget. This way I wont forget.

So basically before is where I am at now. Next week I would need it to be 6000 them 6500 then 7000 etc with same formula. Any help with this thanks


=$CJ31*$CK31+5500

 

[Chameleon64]

Use WEEKDAY() to check if Tuesday has come around and WEEKNUM() to create a formula to increment by 500 each week:

=$CJ31*$CK31+IF(WEEKDAY(TODAY(),1)>=3,5500+(WEEKNUM(TODAY())-25)*500,5500+(WEEKNUM(TODAY())-26)*500)

 

[zone709]

This is what i was looking for. Thanks so much. Was doing it manually and some weeks i forget and have to go back and see what week I missed thanks again.