Create reference formula

[GrahamS]

Here is a screenshot of the spreadsheet i am working with:

https://ibb.co/3smrHPb

I have cells B2, e2, H2 etc calculating % of target achievement that calculates % of target achievement so B2 cell formula is =b24/b4 for sales day 18. Each day i have to manually adjust the formula to reflect the changing day so for day 19 i will have to change the formula to b25/b4. Looking for a formula that would automate this process referencing the sales day in cell A3.

Help greatly appreciated.

Thanks

 

[GrahamS]

Re: How to create reference forula

Is it possible to create a drop down menu for days from 1-22 for cell A3?

NVM. Bit of googling solved it. Thanks again for the help.

 

[nardagus]

Re: How to create reference forula

No problem.