A
Andrew
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
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