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

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

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

Tks Max, Ron!

Kaye

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