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?

1 Reply

@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.