OMG! I will have to look at what you did when I get home tonight but I had no idea it would be that complex - I thought I had done pretty good with my very limited knowledge of Excel but what you did - I don't know what to say....you are awesome! I can't wait to check out your work....You may...
Thank you! Here are the links to my spreadsheets.
I use the Lexington one first, changing the highlighted row to reflect the month in the previous year and the current year.
I add figures for current month, then manually update the formulas to reflect the cells in the months being used.
I...
Every month, I input totals for production, A/R, services, hours, etc. for two dental offices. This is done for the current month & current year, then compared against the last year and month. I calculate from January through the current month (YTD). I have highlighted the numbers for each...