Unique week/month start and end days

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have a Daily Date column as well as at Mileage Qty column.

I want to create a summary report that shows total Mileage Qty per week and per month.

However, my week is Thursday-Wednesday.

Also, my month ends on the 21st and begins on the 22nd.

Any way I can work around this to create an accurate weekly and monthly summary using those parameters?
Photo of Zohreh Karami

Zohreh Karami

  • 120 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Most likely, you'll need to create a Weeks and a Months table and have either the Week Beginning or Week Ending date as your key field for the Weeks table. You would then have a formula on each record that could identify which week it belonged to based on the date.