Hi, I'm Glen Feechan. Welcome to my blog - Not Just Numbers.

Most of my content is aimed loosely at those of a financial bent (I am a Chartered Accountant), with a strong bias towards Microsoft Excel tips.

You can also sign up (below left) and get a free report and regular updates of new posts to the blog. Also have a look at the freebies section for free training videos, etc.

I hope you find the content useful and that every now and again it makes you smile.

Glen Feechan

Email me         Connect on LinkedIn      Follow me on Twitter      Visit Not Just Numbers on Facebook
Glen Feechan

Learn Pivot Tables in Excel 2003 and 2007 - with this FREE video

Tuesday, March 24, 2009

Excel Tip: Reporting by year or month

Some very useful functions in Excel, particularly when reporting on transactional data, are the following date functions:

Year( ), Month( ) and Day( )

For each of these functions, you need only put the cell reference of a date field between the brackets and it returns the year, month (1-12) or day (1-31).

Using Year( ) and Month( ) in particular, you can add additional columns alongside a list of sales or other transactions to strip the year and month from the date column. This allows you to report by these in a pivot table or a simple Autofilter.

0 comments:

Post a Comment

Try these other services from Feechan Consulting Group: