=TEXT(DATE(E5,C5,D5),"ddd")
--
David Biddulph

"Andrew" wrote in message
ups.com...
Hello,

I am grabbing weekday names with this function =DATE(E5,C5,D5) where
E5 is 2007 C5 is 1 and D5 is1 the result is Mon

I wish to look at some data by day of the week so i would like to
convert the result to text so i can then use a conditional statement
to work with the data set by day of week.

yes i am a rank newbie so please be kind if i have somehow made this
harder than it should be

i searched high and low ofr a way to get a text result but to no avail

thanks for your consideration!

Andy