Dayname (English Version)

May 18, 2006 at 3:17 pm 1 comment

I myself often face this problem. That is, what is the dayname of certain date. Before found this multiple formulas from my partner job, Michael HTj, I always use macro. What a stupid way! Thx Mike! Now, I want to share how to get dayname of particular date.There are two ways to have it:

Using format cell

1 Right click on selected range
2 Chose Format Cells…
3 In Number tab, chose Custom
4 Type ddd or dddd in Type textbox
5 To see the result, see in Sample box
6 OK

Using TEXT formula

TEXT(value, format_text)
Value is a numeric value, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.
Format_text is a number format in text form from in the Category box on the Number tab in the Format Cells dialog box. Format_text cannot contain an asterisk (*) and cannot be the General number format.

For this case, set format_text to ddd for simple day (e.g. Sun) or dddd for complete day (e.g. Sunday)

Here are the formulas in cells of C3 and D3:


Entry filed under: Formula, Sedeng.

SUMIF Formula Dayname (Non-English Version)

1 Comment Add your own

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

We Moved!

Kami telah pindah ke

Tweet XQ

Kapsul XQ Terkini



RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

My Popularity (by

Creative Commons License

%d bloggers like this: