is there a formula where I can assign a number to the day of the week.

for instance; if I input "wednesday" can it return "3"?

I want to go a step beyond that and have it return columns "3,14,31 & 54"
but that is detail minor.

Thanks,
Blake

Have a look at the WEEKDAY function in Help,
Regards,
Alan.
"bmo" wrote in message
...
is there a formula where I can assign a number to the day of the week.

for instance; if I input "wednesday" can it return "3"?

I want to go a step beyond that and have it return columns "3,14,31 & 54"
but that is detail minor.

Thanks,
Blake

=MATCH(A1,{"Monday","Tuesday","Wednesday","Thursda y","Friday","Saturday","Sunday"},0)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"bmo" wrote in message
...
is there a formula where I can assign a number to the day of the week.

for instance; if I input "wednesday" can it return "3"?

I want to go a step beyond that and have it return columns "3,14,31 & 54"
but that is detail minor.

Thanks,
Blake

Sorry, misread the question,
Apologies,
Alan.
"Alan" wrote in message
...
Have a look at the WEEKDAY function in Help,
Regards,
Alan.
"bmo" wrote in message
...
is there a formula where I can assign a number to the day of the week.

for instance; if I input "wednesday" can it return "3"?

I want to go a step beyond that and have it return columns "3,14,31 & 54"
but that is detail minor.

Thanks,
Blake