R Rick Rothstein Jan 13, 2011 #2 How can I convert a date to the 'Day of the week'? ie Mon, Tue Let's say your date is in A1, then this... =TEXT(A1,"ddd") will give you the day's name abbreviated and this... =TEXT(A1,"dddd") will give you the full name of the day. Rick Rothstein (MVP - Excel)
How can I convert a date to the 'Day of the week'? ie Mon, Tue Let's say your date is in A1, then this... =TEXT(A1,"ddd") will give you the day's name abbreviated and this... =TEXT(A1,"dddd") will give you the full name of the day. Rick Rothstein (MVP - Excel)
D Don Guillett Excel MVP Jan 13, 2011 #3 How can I convert a date to the 'Day of the week'? ie Mon, Tue ..... Click to expand... If the SAME cell just format it to ddd
How can I convert a date to the 'Day of the week'? ie Mon, Tue ..... Click to expand... If the SAME cell just format it to ddd