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 |
#2
|
|||
|
|||
Try in say B1: =DAY(A1)
-- Rgds Max xl 97 -- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom --- "KC" wrote in message ... 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 |
#3
|
|||
|
|||
Hi KC
=DAY(F1) -- Regards Ron de Bruin http://www.rondebruin.nl "KC" wrote in message ... 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 |
#4
|
|||
|
|||
Tks Max, Ron! Kaye |
#5
|
|||
|
|||
Pleasure` Kaye !
(from us) -- Rgds Max xl 97 -- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom --- "KC" wrote in message ... Tks Max, Ron! Kaye |
Reply |
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 |