Changing a budget template from calendar to fiscal year??

%3CLINGO-SUB%20id%3D%22lingo-sub-1623748%22%20slang%3D%22en-US%22%3EChanging%20a%20budget%20template%20from%20calendar%20to%20fiscal%20year%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623748%22%20slang%3D%22en-US%22%3E%3CP%3EI%20love%20a%20particular%20budget%20template%2C%20but%20it's%20set%20up%20for%20calendar%20year%20and%20I%20need%20to%20change%20the%20formulas%20to%20calculate%20fiscal%20year%20(July-June).%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1623748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I love a particular budget template, but it's set up for calendar year and I need to change the formulas to calculate fiscal year (July-June). How do I do this?

5 Replies

@rtimlin 

 

What's the current formula that calculates things (what things?) based on calendar year? Without knowing that, or how your current workbook functions, it's hard to make any specific suggestions.

 

Ideally, you would post a copy of your much loved workbook, just making sure it contains no personal info.

@mathetes  Hello, I had the same issue but with a calendar template. I want to change the months to begin in august with my fiscal year. I attached the template

That's a template that is protected so users can't change it. You could try sending feedback to Microsoft
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Week4Busn214.xlsZipped Folder: https://people.highline.edu/mgirvin/YouTubeEx...
Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htmIn this video learn about:1. (00:16) Introduction to Entire Project, ...