Forum Discussion

ZohrehKarami's avatar
ZohrehKarami
Qrew Member
7 years ago

Unique week/month start and end days

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?
Formulas and functions
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    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.