Posted to microsoft.public.excel.worksheet.functions

HK[_3_]

external usenet poster

Posts: 15

WEEKDAY

In A1 I have: 26-Feb-2010
Formula:
=INDEX({"Monday","Tuesday","Wednesday","Thursday", "Friday","Saturday","Sunday"};WEEKDAY(A1,2))
returns Friday
whereas formula:
=TEXT(WEEKDAY(A1,2),"dddd") returns Thursday.
(Second argument in WEEKDAY is 2 because here Monday is first day of week)

Why is it that the two formulas return different results?

Hans Knudsen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
weekday() help please?	Totti	New Users to Excel	3	October 28th 08 04:43 PM
WEEKDAY() function: display TEXT not numeric weekday	tom	Excel Discussion (Misc queries)	3	November 21st 06 04:32 PM
WEEKDAY()	Epinn	New Users to Excel	29	September 10th 06 11:39 AM
Weekday	Thomas	Excel Worksheet Functions	6	January 29th 06 01:07 AM
WEEKDAY using IF	lunker55	Excel Discussion (Misc queries)	2	December 4th 04 03:34 PM

All times are GMT +1. The time now is 07:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us