Day of Week

Ron · Jul 16, 2003

I need a formula to convert a cell's date value to what
day of the week it is Eg

Cell A1 = July 16, 2003 I need a formula to convert that
into Wednesday

Any help appreciated

Chip Pearson · Jul 16, 2003

Ron,

Use something like
=TEXT(A1,"DDDD")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]