Skip to main content
Question

Unique week/month start and end days

  • June 14, 2018
  • 0 replies
  • 31 views
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?
    This topic has been closed for replies.

    • ArchiveUser
    • Registered
    • July 14, 2018
    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.
    Terms & ConditionsAccessibility statement