dates
 

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?

dates
 

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?

dates
 

If you want the name of the day (Monday, etc.) then enter =A1 in cell B1 and
custom format it like "dddd".
If you want the No of the day then enter =WEEKDAY(A1,2)
See Help on the second argument (numbering style of the days of the week)

Regards,
Stefi

€žWindy€� ezt Ã*rta:

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?

dates
 

=IF(A1="","",CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue", "Wed","Thu","Fri","Sat"))

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?

dates
 

When I copy this formula down column b, and column a hasn't been filled in
yet, I get a column of "Saturdays". How can I hide the formula so column b
stays blank until column a is filled in?

"FSt1" wrote:

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?

dates
 

You could use a formula:
=if(a1="","",text(a1,"dddd"))

But I'd just format that column of dates:

Select the column
Format|cells|number tab
Custom:
mm/dd/yyyy dddd
(or what you like)



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?

--

Dave Peterson

dates
 

=If(A1="","",TEXT(A2,"ddd"))

Windy wrote:

When I copy this formula down column b, and column a hasn't been filled in
yet, I get a column of "Saturdays". How can I hide the formula so column b
stays blank until column a is filled in?

"FSt1" wrote:


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?

dates
 

hi
=if(A2="","",Text(A2,"dddd"))

Regards
FSt1

"Windy" wrote:

When I copy this formula down column b, and column a hasn't been filled in
yet, I get a column of "Saturdays". How can I hide the formula so column b
stays blank until column a is filled in?

"FSt1" wrote:

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?

dates
 

Your good work is still helping tens of people out there!

Just what I needed for converting dates so I can do pivot tables on months!

Happy New Year!

"FSt1" wrote:

hi
=if(A2="","",Text(A2,"dddd"))

Regards
FSt1

"Windy" wrote:

When I copy this formula down column b, and column a hasn't been filled in
yet, I get a column of "Saturdays". How can I hide the formula so column b
stays blank until column a is filled in?

"FSt1" wrote:

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?