Well I had to try this in Excel and (after fighting the input format), it gave me

  2024-01-30 -> 2024-01-29
  2025-01-30 -> 2025-01-28
Fun. There is so much ambiguity in what “one month” means.

Polars has an offset-by function which is a bit more explicit about how you want to handle date math. “Calendar date” vs number of days.

Edit: just ran polars and I’m not in love with its answer either.