Finding the Financial Year Month Number

  • Thread starter Thread starter Tiffany
  • Start date Start date
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
 
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
Counting dates with specific criteria 1
Copy Paste Financial Years 3
FICA Formula 11
How can I show up and down arrows when a value changes? 1
Excel Formula for years and months 2

Back
Top