J
jspaeth
How do I set up a function that when I "input a date it gives me the day of
the week" in another column?
the week" in another column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PCLIVE
Depending on the format you want displayed.
Full day name:
=TEXT(A1,"dddd")
Three letter day name:
=TEXT(A1,"ddd")
HTH,
Paul
Full day name:
=TEXT(A1,"dddd")
Three letter day name:
=TEXT(A1,"ddd")
HTH,
Paul
M
Mike H
Hi,
Try this
=WEEKDAY(A1)
With a custom format of DDD
Mike
Try this
=WEEKDAY(A1)
With a custom format of DDD
Mike
K
Kevin B
Assuming the date is in A1, create the following formula in the cell you want
the day of the week in:
=A1
Then select the formula cell and click FORMAT, CELLS from the menu and click
the NUMBER tab.
In the CATEGORY column select CUSTOM and then in the text box to the right
of the CATEGORY column enter the following format mask:
dddd
Click OK to exit.
the day of the week in:
=A1
Then select the formula cell and click FORMAT, CELLS from the menu and click
the NUMBER tab.
In the CATEGORY column select CUSTOM and then in the text box to the right
of the CATEGORY column enter the following format mask:
dddd
Click OK to exit.
D
David Biddulph
You don't need the WEEKDAY function, Mike.
=A1 will do the same, if you format as ddd.
=A1 will do the same, if you format as ddd.