Date Range

Hello,

I am trying to run a report for date range of 15th previous month to 14th current month. To be run monthly on the 15th.

I would normally use TODAY-? to TODAY-? but this would not cover the varying number of days per month so would need amending each month.

Is there any formulas that would allow this.

Thank you,

Joe