About Us

quartz[_2_]

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.

psp

Use the TEXT function:

=TEXT(date,"dddd")
where date is the date specifiedin standard date format like 1/18/2005.

good luck,

prashant
(not from Microsoft)

"quartz" wrote:

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.

Tom Ogilvy

Assume your date is in A1

=Test(A1,"dddd")

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
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.

quartz[_2_]

Thanks!

"psp" wrote:

Use the TEXT function:

=TEXT(date,"dddd")
where date is the date specifiedin standard date format like 1/18/2005.

good luck,

prashant
(not from Microsoft)

"quartz" wrote:

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.

Tom Ogilvy

Whoops, typo

=Test(A1,"dddd")
should be

=Text(A1,"dddd")

the cell could also be custom formatted using dddd
--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Assume your date is in A1

=Test(A1,"dddd")

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
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.

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

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

Menu

About Us