| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
extracting dd from dd/mm/yy
Hi,
How can I extract the day from the date, ie date is "31/12/04" - need "31" returned in an adjacent cell. I need to have "31" returned as a numeric tho rather than date format, so formatting the cell with "31" as "dd" isn't my solution. Any help greatfully appreciated. Cheers, Kaye |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| extracting cell location | Excel Discussion (Misc queries) | |||
| EXTRACTING TEXT | Excel Discussion (Misc queries) | |||
| extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions | |||
| extracting comments | Excel Worksheet Functions | |||
Threaded Mode
