Add value to cell based on day of the week

[socals]

Hello, I have searched for an answer but I am probably asking the wrong question. What I am looking to do is a create a cell that will start with a value of zero and every Thursday it adds a 2 to the number already there. I'm sure it's possible but I can't seem to find anything.

I thank you in advance for your time!

 

[Joe4]

It can be done, but it can be a bit tricky, unless you also are also storing a date stamp somewhere.
Otherwise, if you open it more than once on any given Thursday, how is it to know if you have already opened the file? Or what if you don't open a file on a particular Thursday?

What might be better (if possible), is store the initial date somewhere, and count how many Thursdays have passed since that date, and multiply by 2.

Does that sound like a feasible solution?

 

[socals]

It sure does. I will search for how to do that. Thank you for your time!

 

[Joe4]

You are welcome!

Here is a good link for showing the number of certain days of the week between two dates: https://exceljet.net/formula/count-day-of-week-between-dates