Formula ? Change number on every Tuesday of the week

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
2,137
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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)
 
Last edited:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,739
Messages
6,192,740
Members
453,755
Latest member
IQBS

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top