Office 2007-
I receive weekly sales data (Excel spreadsheet) from 6 of our customers and monthly sales data from a seventh customer. Each of their "Week Ending" is slightly different. One customer's week might end on a Friday, another on a Saturday and others on Sundays. I would like to run YTD, MTD, and Week to Date sales reports based off of my company's calendar.
We end our weeks on Saturdays and refer to each week as Jan WK 1, Jan WK 2, etc... What I want to do is to take the all of our customers' week endings and just match it with my company's week, this way when I run a report I can give my users the option to select the report they want based on YTD, Month to Date, or just a specific week. Can anyone give me any suggestions please?