2002 excel microsoft training - "Month" Function

The UK's most regular instructor-led training courses.
Training information: 2002 excel microsoft training · Microsoft+excel+training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

"Month" Function

by - Vicki [guest] (2007 Feb 22 Thu, 12:42) Reply

I am trying to set up a spreadsheet and am using the Month function as part of a calculation to enter a 'period' number in a cell based on the date in another cell. Because I am working to a financial year (April to March) it takes it across a 'year' which results in a minus number for Jan, Feb and March in the next year. How can I 'tell' Excel that 2008 dates are next year?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: "Month" Function

by - trainer Orok bronze contributer [29 posts] (2007 Feb 22 Thu, 14:46) Edited on 2007 Feb 22 Thu, 14:48 Reply

Hello Vicky

A possible solution is to introduce a new column that uses an IF function to adjust for your financial year being April to March.

Suggested formula
=IF(E4<=0,E4+12,E4) where E4 is the cell showing -2 for January

Hope this helps

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Excel in the Home Office
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips