Return day name from a date
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.
|