I have the date in Column A (ex. 4/14/2014) I want to have the day of the week that corrosponds with that week to automaticlly display in Column C. How can I accomplish this?
I have the date in Column A (ex. 4/14/2014) I want to have the day of the week that corrosponds with that week to automaticlly display in Column C. How can I accomplish this?
Try =A1 and format cell as dddd
Never use Merged Cells in Excel
Hi
Maybe with thisFormula:
Please Login or Register to view this content.
Regard
micope21
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Another way
![]()
Please Login or Register to view this content.
Why not just this
=TEXT(A1,"dddd")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks