Dayname (Non-English Version)

May 22, 2006 at 2:30 pm Leave a comment

Unfortunately, Ms Excel just support English date format campared with OpenOffice.org (OOo) Calc. So, you can’t perform the previous tips of Dayname (English Version) if you want to use another language. This weakness makes us more creative to create multiple formulas. We will take the advantages of CHOOSE and WEEKDAY formulas.

CHOOSE(index_num, value1, value2, )
Index_num specifies which value argument is selected. Index_num must be a number between 1 and 29, or a formula or reference to a cell containing a number between 1 and 29.
If index_num is 1, CHOOSE returns value1; if it is 2, CHOOSE returns value2; and so on.

WEEKDAY(date, type)
type 1 or omitted return integer 1-7, where 1 for Sunday and 7 for Saturday
type 2 return integer 1-7, where 1 for Monday and 7 for Sunday
type 3 return integer 0-6, where 0 for Monday and 6 for Sunday

This example shows how to get dayname in Bahasa.

Using same case with previous posting, Dayname (English Version), use this formula in cell of C3:
=CHOOSE(WEEKDAY(B3),”Ahad”,”Senin”,”Selasa”,
“Rabu”,”Kamis”,”Jum’at”,”Sabtu”)

Entry filed under: Formula, Sedeng. Tags: .

Dayname (English Version) Goal Seek

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


We Moved!

Kami telah pindah ke www.excelquotient.com

Tweet XQ

Kapsul XQ Terkini

Archives

Annex


Langganan
RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

Ranks
My Popularity (by popuri.us)

Lisensi
Creative Commons License

%d bloggers like this: