dates

[Windy]

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?

 

[FSt1]

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


Regards
FSt1

 

[Stefi]

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:

 

[Bob I]

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

 

[Windy]

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?

 

[Dave Peterson]

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)

 

[Bob I]

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

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]

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

Regards
FSt1

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?

 

[LinLin]

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!