2002 excel microsoft training - "Month" Function

Resolved · Low Priority · Version Standard

Thu 22 Feb 2007, 12:42 Vicki (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?

Thu 22 Feb 2007, 14:46 Edited on Thu 22 Feb 2007, 14:48 Trainer 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips