dynamic range (based on current date/month)

users
#1

Perhaps I have databases on the brain, but a database seems like a simpler solution than a spreadsheet.
      What is confusing to me is the YTD column. I thought Year To Date meant the total from January to the current date. With this assumption, a simple SUM() of the monthly totals for each salesman would always give you the year to date total.
      But I still think a database would be better. With it you could enter the daily (or weekly) sales of each representative and let the database do the all the calculations for you including weekly, monthly, year to date, and annual totals in one or more queries. It likely will require the use of SQL in the queries though. Specifically, it may require the use of the GROUP BY clause and doing this in SQL View.

Dan