Excel formula to set "one month/year" before?

Question

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

Answer 1

For month you can use EDATE function:
=EDATE(TODAY,-1)

For years you need to use more complex functions:
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))