Help With Dynamic Revenue Report [Updated]

[NetEcho]

Hi guys,

I am currently trying to tackle a new report for work. The purpose of the report is a summary of daily financials that tracks current day, month to date and variance to budget. I have had a report like this before but it had 31 tabs and formulas would break all the time rendering the report useless. I currently get a report like this every day anyway but certain people in the office want it before I enter the data into our accounting system. My goal here is to have minimal tabs I.e. Report Tab (the tab that gets emailed out), a Daily Matrix Tab where maybe each day has it's own column, and a budget tab. However I'm unsure of how to go about having the report tab generate the Daily, MTD and Variance column based off what columns are filled in I.e If Column A is the only one with numbers that Daily is as of the first of the month and MTD is the same as Daily. and if Column V has numbers it knows That Today is the 22nd and MTD needs to Sum Columns A - V, however the only method I can think of is to make an extremely large and unreadable nested IF statement. Any thoughts and guidance is greatly appreciated.


[UPDATE]

I have attached my current working file below where I have used COUNT and OFFSET to achieve this, I am wondering if I could be doing it more effectively

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[NetEcho]

Here is the file