Forum Discussion
Max_ie
Dec 24, 2021Copper Contributor
Help with a DATE formula
Hi, newbie here... I am wanting to have my spreadsheet keep track of my Crypto auto-buys. So, each week my cryptocurrency site automatically buys a certain amount Bitcoin (BTC) and it is added to...
Riny_van_Eekelen
Dec 24, 2021Platinum Contributor
Max_ie You could use a formula that calculates the number of whole weeks that have past since your first buy. In its simplest form, that could look something like this:
where A5 contains =TODAY()