Return day name from a date

Posted to microsoft.public.excel.programming

quartz[_2_] quartz[_2_] is offline

external usenet poster

Posts: 441

Return day name from a date

I know you can use WEEKDAY to return the NUMBER of the day. But how can I use
a formula on a spreadsheet (or a macro in VBA) to return the name of the day
spelled out? For example:

01-18-2005 should return "Thursday"

Thanks in advance.

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
Return date if in range, else return blank	LisaL	Excel Worksheet Functions	1	July 22nd 09 03:23 PM
return a date from range, date is between dates in two other cells	NN	Excel Discussion (Misc queries)	1	September 28th 06 10:05 PM
Date Function formula that will return the date of a specific week	Greg	Excel Worksheet Functions	4	June 12th 06 05:07 PM
Date formula: return Quarter and Fiscal Year of a date	Rob	Excel Discussion (Misc queries)	7	May 11th 05 08:48 PM
calc constant date from variable date & return with ability to rn.	SusieQ'sQuest	Excel Worksheet Functions	1	November 9th 04 08:51 PM

All times are GMT +1. The time now is 03:38 AM.

Menu

About Us