hi
column A column B
2/5/2007 =TEXT(A2,"ddd") = Tue
=TEXT(A2,"dddd") = Tuesday


Regards
FSt1

"Windy" wrote:

column a will be filled in with dates as needed; how do i get column b to
automatically fill in the corresponding day of the week to match that date?