98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - "Month" Function
2002 excel microsoft training - "Month" Function
Resolved · Low Priority · Version Standard
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome 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. |
