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?
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
