Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - "Month" Function

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

2002 excel microsoft training - "Month" Function

Resolved · Low Priority · Version Standard

Reply Thu 22 Feb 2007, 12:42Vicki (guest) said...

"Month" Function

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 22 Feb 2007, 14:46 Edited on Thu 22 Feb 2007, 14:48Trainer Orok said...

RE: "Month" Function

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

Excel articles

· Excel: Survival Of The Fittest
· How To Sort A List Of Vehicle Number Plates In Year Order In Excel 2010
· Discover The Secret Of How To Conditionally Format An Excel Chart
· Spreadsheets: What's In A Name?
· Microsoft Excel Courses Teach Advanced Macro Techniques

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips