I have to create a dataset with intervals (month and year).
Does it exist a formula that give me the same day but 1 month/year before?
I know I can use
=today()-30
or
=today()-365
but not all month are by 30 days (and the same for years).
I know I can use =day() to extract the day then compose it with the =month()-1 and so on