extracting dd from dd/mm/yy

K

KC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting dd/mm/yy to mm/dd/yyyy 3
Difference between two date/time values 6
convert 13.11.2009 general to 13/11/2009 date, how to 2
change DD/MM/YY to MM/DD/YY 6
Excel is seeing the date as dd/mm/yyyy 4
Date format in Excel 2007 mm/dd/yy not appearing correctly 2
can I change the date format as dd-mm-yy 7
Got dates in dd/mm/yy, Excel refuses to understand this 1

Top