Getting wrong output by year formula

**mso3** · 05-19-2015, 12:01 AM

Hi friends,
I want to have a financial year in devanagari font. For it I used text and year function combination and a code of devanagari font but I’m getting wrong output in cell v2. It should be as ‘2015-2016’ in devanagari font and not in English.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you.

**adhawan06** · 05-19-2015, 12:22 AM

Hi MSO3,

Try the following function and let me know if it works at your end.

Formula:

Please Login or Register  to view this content.

Cheers!!!
Anil Dhawan

**azumi** · 05-19-2015, 12:25 AM

Maybe :

=TEXT(M2,"[$-9]yyyy")&" - "&TEXT(M2,"[$-9]yyyy")+1

**adhawan06** · 05-19-2015, 12:31 AM

Originally Posted by azumi

Maybe :

=TEXT(M2,"[$-9]yyyy")&" - "&TEXT(M2,"[$-9]yyyy")+1

What my understanding says your formula will not return the year in devanagari font as asked by OP. Your result will return to 2015-2016 instead of "२०१५-२०१६". Correct if my understanding is wrong.

Cheers!!!
Anil Dhawan

**azumi** · 05-19-2015, 12:53 AM

Hi adhawan, Thanks for reply, yes you right, miss read the requirement, change to :

=TEXT(DATE(YEAR(M2),1,1),"[$-4000000]yyy")&"-"&TEXT(DATE(YEAR(M2)+1,1,1),"[$-4000000]yyy")

hope this works

**mso3** · 05-19-2015, 02:11 AM

Hi Anil,
Thank you. It's working fine.

Please let me know for which devanagari font the code [$-4010000] is used.

Thank you.

**mso3** · 05-19-2015, 02:18 AM

Hi azumi,
Perfect! It's working fine.

Thank you.

**adhawan06** · 05-19-2015, 02:38 AM

Originally Posted by mso3

Hi Anil,
Thank you. It's working fine.

Please let me know for which devanagari font the code [$-4010000] is used.

Thank you.

Hi MSO,

I just tested it with the standard Hindi Devnagari font code which is [$-4010000]. However, you can use any one [$-4010000] or [$-4000000].

Also, you can use [$-4390000] too as the [$-439] font code uses for Hindi. E.g. If you want to return to "मई", then you can try with "=TEXT(M2,"[$-439]mmmm")"

You can also refer to the region wise code list. Specifying_a_Language_for_the_TEXT_Function

Also, I have found where you have posted the same thread just few months back - Old Post

Let me know if my answers work for you.

Cheers!!!

Anil Dhawan

**mso3** · 05-19-2015, 07:22 AM

Hi Anil,
Thank you.

Sorry I forgot the formula and also the post.

The formula is working fine but just for information I asked you.

Please do use url tag for links to open it from the post instead of html tag.

http://www.excelforum.com/excel-form...yy-format.html

Thank you and have a nice day.

**adhawan06** · 05-19-2015, 07:26 AM

Originally Posted by mso3

Hi Anil,
Thank you.

Sorry I forgot the formula and also the post.

The formula is working fine but just for information I asked you.

Please do use url tag for links to open it from the post instead of html tag.

http://www.excelforum.com/excel-form...yy-format.html

Thank you and have a nice day.

Thanks for correcting me...Yeah I forget to add url tag and used html. :P

You too have a nice day...

Getting wrong output by year formula

LinkBack

Thread Tools

Rate This Thread

Display

Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Re: Getting wrong output by year formula

Thread Information

Users Browsing this Thread

Similar Threads

Match year of date to year of date specific range of dates, output corresponding value.

formula to output upcoming quarter end date (for a broken fiscal year)

Quotation marks in formula giving wrong output

Getting false when i should be getting true in (=INT(CELL)=CELL)

Excel assumes wrong year when year omitted

Bookmarks

Bookmarks

Posting Permissions