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
Copying a cell if dates match 2
YTD SUMIF based on current date 3
Expanding Date Formula 0
Counting dates with specific criteria 1
Drop Down List Dependant Formula 2
Find next Sunday 7

Top