Excel question

ZFR · 03-28-2007, 04:42 AM

Is there an excel function that takes the date from another cell and returns the day of the week? Or am I forced to use macros?

EDIT: Using Office 2002.

EDIT2: if it's not possible in excel but possible in open office, I'll be finally convinced to switch.

[ 03-28-2007, 04:45 AM: Message edited by: ZFR ]

Legolas · 03-28-2007, 05:06 AM

There is.

ZFR · 03-28-2007, 05:16 AM

Thank you. That's just what I needed.

03-28-2007, 04:42 AM	#1
ZFR Legion Symbol Join Date: February 14, 2002 Location: Ireland Age: 40 Posts: 7,368	Is there an excel function that takes the date from another cell and returns the day of the week? Or am I forced to use macros? EDIT: Using Office 2002. EDIT2: if it's not possible in excel but possible in open office, I'll be finally convinced to switch. [ 03-28-2007, 04:45 AM: Message edited by: ZFR ] __________________ ZFR

03-28-2007, 05:06 AM	#2
Legolas Jack Burton Join Date: March 31, 2001 Location: The zephyr lands beneath the brine. Age: 40 Posts: 5,459	There is. __________________ Say NO to the Trouser Tyranny!

03-28-2007, 05:16 AM	#3
ZFR Legion Symbol Join Date: February 14, 2002 Location: Ireland Age: 40 Posts: 7,368	Thank you. That's just what I needed. __________________ ZFR

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with Excel..	Kakero	General Discussion	3	11-15-2005 06:13 AM
Need to create a drop-down checklist box for EXCEL...	quietman1920	General Discussion	1	07-14-2005 02:25 PM
VBA in Excel	Jorath Calar	General Conversation Archives (11/2000 - 01/2005)	5	02-10-2004 11:18 AM
Help with excel and logarithmic scales	philip	General Conversation Archives (11/2000 - 01/2005)	8	12-31-2003 07:22 PM
Excel...Some Help Needed...	FelixJaeger	General Conversation Archives (11/2000 - 01/2005)	4	04-22-2003 08:58 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)