Finding the Financial Year Month Number

T

Tiffany

Hi there,

I'm trying to find a formula to return the month in the financial year, eg
Oct is month number 4, but the month() function is based on calendar year.
Can anyone help??

Thanks in advance
 
M

MartinW

Hi Tiffany,

There has to be a bettter way but this should work,

=IF(MONTH(A1)<7,MONTH(A1)+6,MONTH(A1)-6)


HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Financial Year Month Number 3
find out specific month and year 1
Counting dates with specific criteria 1
Copying a cell if dates match 2
Excel Vba to change displayed year automatically. 14
How to get month number for fiscal year starting in Oct. 3
Month in formula 3
Finding 3rd (or 2nd) Sunday in a given year/month 5

Top