Excel Tutorial Library header
borderAccounting Calendarborder
border Added to Library on 05 Oct 2008
Length: 6 mins

View Tutorial Movie
Download Tutorial Movie (avi)
Download File Used



This short presentation show you how to create an accounting calendar spreadsheet in Excel. It takes an example from a member of the site and shows how, with some simple equations, it can fully automated. So that next year the financial calendar can be created by just changing just one cell.

This presentation will give also give you a good background on how to format date cells in Excel.

The Original example and the complete example are available for download.


Related Tutorials:
getting started with dates and times
Master Excel Dates Functions

Feedback for this tutorial:
"I thought this was very helpful I can't wait to practice this"

"Excellent tutorial on the topic. Simple and well explained.
How do you treat the correct starting Wednesday for 2009 which is 31/12/2008? or do you start with 7/1/2009?"


borderborder