Thanks. I have simplified it by replacing OR with < for Indian financial year. Here is the formula. =IF(MONTH(A2)<4, YEAR(A2)-1&"-"&YEAR(A2), YEAR(A2)&"-"&YEAR(A2)+1)
vinodsajnani
Thank you so much for or this tutorial!! It is so helpful!!! 👍
jiayuezhan
My organization's fiscal year runs July - June so I modified this and just used < instead of the OR function. =IF(MONTH(A2)<7, YEAR(A2)-1&"-"&YEAR(A2), YEAR(A2)&"-"&YEAR(A2)+1)
Bartaneo
Thank you so much for this video. It helped me save alot of time.
SarvilDedhia
Very useful Topic
Great video
< can be used in stead of OR
dinzakas
Very clear and extremely useful thank you
charlotteeveritt
Thanks sir. For same output in ms access what is expression in ms access
santars
Can I find months from financial year? Means totally reverse of this video, 2013-14 results start month and last month
ranarizwanahmed
How we can use array formula over hear
bankim
how to i get financial year as 21-22
pls share formula for the same
kualisindia
I hope it will give me right answer bcz all the video I followed gave error "too many arguments use in this formula"
poojathakur
I have two columns with start date and end date how can i extract year of both column to single column ex 3/5/2020 to 7/7/ 2021 i need "2020 - 2021"
Please help
praveen
Hi i tried using the same formula (=if(or(Month(J2)=1, (Month(J2)=2, (Month(J2)=3), Year(J2)-1&"-"&Year(J2), Year(J2)&"-"&year(J2)+1)) - it is giving me an error - please help
My date format is 14/03/2019 - please help
sameenas
This is what I am looking for but Instead of FY I want to show its Financial year Ending Date with respect to its Start Date 17 March 2009 its 31 March 2009, 18 November 2013 its 31 March 2014 How to show it in excel can you help me with the
kittunitu
The formula is wrong as it is calculating month June for next financial year, example Date 8-jun-13 should be financial year 2012-2013 (July till June) but its calculating as 2013-2014
