| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
