get date function result as text
 

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

get date function result as text
 

Not sure why you need to turn it into text. Have a look at the WEEKDAY
function in Excel Help - this returns a number which corresponds to
the day of the week (1 - 7), so you can apply an IF function to this.

Hope this helps.

Pete

On Feb 27, 1:08 am, "Andrew" wrote:
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

get date function result as text
 

=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