Excel 2013 Template Problem

Question

The new Semi-Monthly Home Budget Template (which is downloaded from Microsoft when you select new file in Excel 2013) has an error that I'm not sure how to correct.  When you open the template file, before you enter any data (generic data is already in the file), on the first tab (called Dashboard), the information populating the bottom half of the screen (it shows every month with 4 rows: Income 1-15, Income 16-EOM, Exp. 1-15 and Exp 16-EOM has an error. 

The error occurs with the automatic populating of the data as it lists the information in the wrong column meaning information for March is showing in the February column, February data is show in the January column, etc.  What is strange is the top part of the page lists the information correctly.  How do you fix the bottom so that the information appears correctly for each month?

Answer 1

Thank you so much Herbert. I had a brain haemorrhage 4 years ago and so I am not as quick as I used to. Needless to say I have been struggling for over 3 days trying to work this out.

Now I can comfortably adapt this spreadsheet to meet my needs.

Kind regards

Mark

Answer 2

Excel 2013

Formed Table1 at Dashboard and edited its formulas.

http://www.mediafire.com/download/5e4xf22snq89tt2/11_29_15a.xlsx

Answer 3

Hi, did you resolve this problem? If so how?

Thanks

Mark

Answer 4

Hi, I am having this same problem. How can the issue be resolved please?

I am using windows 10 and office 2016

Answer 5

Hi,

Welcome to Microsoft Community and thank you for bringing this formula error in the Excel template to notice.

Refer to the following link and click on the ratings to provide a feedback about the formula error:

http://office.microsoft.com/en-us/templates/semi-monthly-home-budget-TC103428919.aspx

If you have any query and issues with Office suites and office related products, reply and we will be happy to assist you.

Thank You