Thread: How can I put in Date & have the Day come up
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How can I put in Date & have the Day come up
"larry" wrote:
What i am trying to do is put in date ie:- 30/12/07 and have sunday.
.. =a1(date), b1(day)

Presuming A1 down contains real** dates,
then in B1, copied down:
=TEXT(A1,"dddd")
will return the required day.

**Think your posted example: 30/12/07 is not a real date
To convert an entire col of dates to real dates at one go,
select the col, click Data Text to Columns, click Next Next
In step 3, check "Date", select: DMY from droplist, click Finish
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote