Hello all-
I have data recorded on a daily level that I would like to summarize by month however there is a catch. I would like to compare the previous months data to the current month by the number of working days left.
For example todays date is 10/22/05 and there are 6 working days left in the month. I want to look at all previous months for the year and see what our totals were with 6 working days remaining.
The end result will give me two totals for each month where I can look at it and go "In January, with 6 workdays left we had already sold 10 widgets, and in those remaining 6 workdays we sold 5 more widgets, compared to this month where we've sold 18 widgets with 6 workdays remaining"
Using the Today() function I can get the beginning date of the current month, end date of the current month, total working days, working days completed, and working days remaining, (counting the current day as completed) those are all not a problem.
The date is obviously different for each month, September 22 is the date in September when there were only 6 workdays left (Counting the current date as completed), August 23rd is the date in August when there were only 6 workdays left. etc etc.
My data source is very simple. It is ascending daily dates in column A with the data in column B.
It's hard to translate my thoughts into a post but I hope I've drawn a good picture for you. I look forward to your responses.
Bookmarks