dates

W

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?
 
F

FSt1

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


Regards
FSt1
 
S

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:
 
W

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?
 
D

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)
 
B

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?

:
Click to expand...
 
F

FSt1

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

Regards
FSt1

Windy said:
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?
Click to expand...
 
L

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!
 
Top