(C) 2009 - 2014 by Mourad Louha · All rights reserved

All posts tagged Fiscal Year

Someone in the US asked me, if it should be possible to modify my multiple year calendar template so that it reflects the current fiscal year by starting on August and ending on July. After I had done and tested the changes, I thought to share the special version here.

In the settings sheet, you will find new options for setting up the start month and the fiscal year. When entering notes and dates in the notes sheet, the year is automatically calculated according your settings. The holidays are also calculated for both years. For example, if you choose August 2012 as start month, the Easter holidays are calculated for 2013.

Multiple Year Calendar for fiscal years

Finally, I also modified the formulas used in the week, month, quarter and year views for showing the dates. You can download the Excel 2007 and above file from following link. Please note, that I have only changed the US Version of the calendar, but I am also planning to update the version for the other countries.