Our company, along with almost all retail companies in the US, leverages a standard retail calendar - either 4-5-4 or 4-4-5, meaning that each month starts at the beginning of a week and ends are the end of the week regardless of the date, so January is 4 weeks, Feb is 5 and March is 4, etc. This allows us to report and roll up weeklies easily. It also allows for much cleaner YOY comparisons. We also start our weeks on Sunday and need reporting to align. Salesforce defaults to a Sunday start and doesn't let you report Monday to Sunday, so our weekly reports can NEVER line up since you are the opposite and start on Monday. There should be a way to define weeks and months (or fiscal periods) in the calendar so all reports leverage those definitions.
...read more