Today one of my friend asked me, the Formula to converts Date into Financial Year in MS Excel. I thought it is better to explain the same in my blog for the interest of other visitors.
Formula :
Financial Year is 12 Months period which usually the Company follows according to their Accounting Policy. Here, I am going to explain you the Formula for the Financial Year which starts from the 1st Day of April Month and ends on 31st Day of March Month in the Following Year.
For Example, the Financial Year of 04 February, 2012 is 2011-12
Formula :
=IF(MONTH(A1)>3,"FY "&YEAR(A1)&"-"&RIGHT(YEAR(A1)+1,2),"FY "&YEAR(A1)-1&"-"&RIGHT(YEAR(A1),2))
Functions used in the Formula?
The formula consists of the following Excel Functions
- Logical Function - IF
- Date Functions - Month & Year
- Text Function - Right
How the Formula Works?
In Simple Text..
If the Month number of the Date is Greater Than 3 (three).. then the result should be the Year of the Date and Following Year of Date or else, the result should be the Prior Year of the Date and Year of the Date. Of course, Hyphen symbol (-) between these two years.
RIGHT Function in the Formula is just to format the result. If we want the result as FY 2010-2011 then RIGHT function is not required. But we want to show the result as FY 2010-11 then we have to use Right Function (How to use Right Function in MS Excel). Right Function will results the last two characters of the second part of the result.
& symbol in the Formula is to combine all parts of the result. Even you can use CONCATENATE Function for the same result.
Dear Friend,
ReplyDeleteI stand here with a problem to be solved.
I have two (trial balances)excel sheets with same figures but while entering data I missed out some figures in 2nd sheet which was entered manully.
so my problem is how to solve this problem.
Thanks in advance
Anupama Asst.Manager (F & A)
Dear Anupama,
ReplyDeleteI think you are talking about the effect on 2nd sheet , while editing the first one. If so, kindly check whether both the sheet has been selected, change made in one sheet will affect the same cell in 2nd sheet, Deselect the sheet by clicking on the sheet name
Thank you for a great post. Worked wonders in minutes.
ReplyDeleteNice post.
ReplyDeleteThanks a Million!!!
ReplyDeleteOo Honey
ReplyDeleteBundle of Thankssssss
Very useful, saved me lots of time - many thanks!
ReplyDeleteVery useful post. I used the same formula for my MS Access Report to get the financial Year. I replaced IF with IIF. Thank you very Much
ReplyDeletereverse possible hai kya?
ReplyDeleteLovely
ReplyDeleteREALLY HELP ME A LOT.... IN MY OFFICIAL WORK.. THANK YOU FOR THIS POST
ReplyDeleteWorks like dream... .. Thanks.
ReplyDeleteTHANKS ........
ReplyDeleteTHANKS ........
ReplyDeleteExcellent !
ReplyDeleteThanks. Saved me a lot of time.
Excellent !
ReplyDeleteExcellent formula. Saved me a lot of time experimenting.
ReplyDeleteWow, great post.
ReplyDeleteYou talk about financial formula convert way. I have seen this formula very seriously. I need information finance homework help. I know that you are expert about financial. So You are able to help me.
ReplyDeleteIt can be a good thing to be done here with because these are the favorable objects being created out here and usually considered to be more important.
ReplyDeleteNice blog. I understand that we all need these formulas for financial assignment. I need an expert which can do best job for me in finance. http://www.cheapproofreading.net/accurate-and-cheap-proofreading/
ReplyDeleteShare your mail regarding your need
ReplyDeleteI need an expert which can do best job for me in finance
Wow very nice post its information is really wonderful. Please Visit:
ReplyDeletelearn financial modeling
auto repair shop business plan
finance excel template
Excel has lot of good formulas and such one used for making things in right direction. The conversion of things in order leads for use such one for needy aspects. This mention in http://www.punctuationcheck.org/correct-punctuation-checker-must-haves-of-any-punctuation-tool/ fro more uses.
ReplyDeleteEye to eye association is imperative while giving presentation. A mediator must keep an eye to eye association with the gathering of spectators so they are remaining careful and dynamic in presentation. It http://www.originalitychecker.net/ fear of open talking from mediator.
ReplyDeleteGood post,, They should not empower understudies to save from preoccupations. Until the point, that adaptable would be on they would be involved by purposeless activities. This http://www.paprograms.org/ucf-physician-assistant-program/ site help you to find more things.
ReplyDeleteIt is really important to learn the different functions of excel in order to make different financial model. Basic understanding of the excel functions can make significant thing to the SaaS Financial Model which is also relevant to this formula.
ReplyDeleteThank you so much it works and important formula
ReplyDeleteIt is super blog, I would like to be like you.
ReplyDeleteexcel financial model template
hospital financial model xls
Mining Valuation Model
Dear sir
ReplyDeletei want to convert date in different cell like a1=10(date), b1=12(month), c1=2018(year) in f.y. like 2018-19 so please guide me
this really helps, i have one query, exp FY20 FY starts from Apr2019 and ends Mar2020, any date comes under between two then it will be FY20, so how to apply this furmula to get only FY20 not FY19-20 from date , i would be great if you help on this . after used this i got FY 19-20 but i am loking for only FY20(apr2019-mar-2010, FY19(Apr-2018-Mar-2019)
ReplyDeleteExcellent.. Fabulous.. Superb..
ReplyDeleteVery nice formula. Saved my a lot of time. Thanx....Bro...
ReplyDeleteWell Done.. I admire the value you have provided through the web.. This will for sure going to be helpflul for all..If you are small firm lookking for the accounting and bookkeeping services , here are my services listed below:
bookkeeping services
Online bookkeeping services
outsourced bookkeeping services
best bookkeeping services
best Online bookkeeping services
Online bookkeeping
Thanks for sharing. I really like this article. You provide very useful information. I am also done Excel course in Lahore from digital training. If any one interested in Excel course in Lahore then, I recommend digital training.
ReplyDeleteyozgat
ReplyDeletesivas
bayburt
van
uşak
48OM
görüntülü show
ReplyDeleteücretlishow
PRZ
sakarya evden eve nakliyat
ReplyDeleteosmaniye evden eve nakliyat
aksaray evden eve nakliyat
çanakkale evden eve nakliyat
zonguldak evden eve nakliyat
KGOOY3
maraş evden eve nakliyat
ReplyDeletemalatya evden eve nakliyat
ağrı evden eve nakliyat
elazığ evden eve nakliyat
aydın evden eve nakliyat
B1POO
href="https://istanbulolala.biz/">https://istanbulolala.biz/
ReplyDelete6KEEZE
D3839
ReplyDeleteKaspa Coin Hangi Borsada
Aydın Evden Eve Nakliyat
Çerkezköy Çamaşır Makinesi Tamircisi
Poloniex Güvenilir mi
AAX Güvenilir mi
Muğla Parça Eşya Taşıma
Antalya Lojistik
Afyon Parça Eşya Taşıma
Sakarya Parça Eşya Taşıma
875B2
ReplyDeleteArdahan Şehir İçi Nakliyat
Afyon Parça Eşya Taşıma
Karapürçek Fayans Ustası
Gümüşhane Lojistik
Balıkesir Lojistik
Yalova Lojistik
Giresun Şehir İçi Nakliyat
Arbitrum Coin Hangi Borsada
Muğla Parça Eşya Taşıma
B150A
ReplyDeleteKilis Evden Eve Nakliyat
Çerkezköy Korkuluk
Bitci Güvenilir mi
Burdur Evden Eve Nakliyat
Isparta Evden Eve Nakliyat
Çerkezköy Televizyon Tamircisi
Ardahan Evden Eve Nakliyat
Edirne Evden Eve Nakliyat
Keçiören Boya Ustası
50317
ReplyDeleteÇerkezköy Halı Yıkama
Şırnak Evden Eve Nakliyat
Hatay Evden Eve Nakliyat
Tokat Evden Eve Nakliyat
Ünye Kurtarıcı
Ankara Fayans Ustası
Etimesgut Fayans Ustası
Maraş Evden Eve Nakliyat
Kripto Para Borsaları
4BEB4
ReplyDeleteHakkari Evden Eve Nakliyat
Düzce Evden Eve Nakliyat
Kalıcı Makyaj
buy testosterone enanthate
sustanon
Bilecik Evden Eve Nakliyat
buy trenbolone enanthate
Şırnak Evden Eve Nakliyat
testosterone propionat for sale
E3144
ReplyDeletekomisyon indirimi %20
C29E4
ReplyDeletereferans kodu binance
3D497
ReplyDeletebinance referans kodu
resimli magnet
resimli magnet
referans kimliği nedir
referans kimliği nedir
resimli magnet
binance referans kodu
binance referans kodu
binance referans kodu
CB377
ReplyDeleteSnapchat Takipçi Hilesi
Twitch İzlenme Hilesi
Qlc Coin Hangi Borsada
Bitcoin Kazanma
Twitter Trend Topic Satın Al
Coin Nasıl Üretilir
Apenft Coin Hangi Borsada
Bitcoin Nedir
Satoshi Coin Hangi Borsada
5400B
ReplyDeletecointiger
binance referans kodu
sohbet canlı
türk kripto telegram grupları
paribu
btcturk
kripto para telegram
paribu
kripto para haram mı
4BB55
ReplyDeletegate io
binance
kucoin
kaldıraç nasıl yapılır
probit
mexc
paribu
toptan mum
binance 100 dolar
xcvgfdgdfgfyhrt
ReplyDeleteفني تصليح افران
GTHTGJHN
ReplyDeleteشركة تسليك مجاري بالخبر
gfhjykyjyjyuk
ReplyDeleteشركة مكافحة النمل الابيض بالاحساء
شركة تسليك مجاري بالدمام C0yFIREQs2
ReplyDeleteشركة تسليك مجاري بابها IaA5ZUT3NG
ReplyDeleteشركة مكافحة النمل الابيض بالاحساء NeGWcBvniO
ReplyDeleteشركة رش مبيدات بالاحساء DCeJSZv9XY
ReplyDeleteشركة عزل مواسير المياه بالقطيف wUTouRSQP1
ReplyDeleteشركة تركيب طارد الحمام بخميس مشيط oQkyNYdvOh
ReplyDeleteشركة عزل اسطح براس تنورة hjxcQQGSOL
ReplyDelete<a href="https://aljanub-jazan.com/%d8%b4%d8%b1%d9%83%d8%a9-%d8%aa%d9%86%d8%b8%d9%8a%d9%81-%d9%85%d8%ac%d8%a7%d9%84%d8%b3-%d8%a8%d8%ac%d
ReplyDelete