Split mm/dd/yyyy into dd only
 

Can someone tell me how I can take date information in a cell such as
08/10/2005 and return only the day value such as 10?

Split mm/dd/yyyy into dd only
 

Use the DAY function. E.g.,

=DAY(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"tomwashere2" wrote in
message
...
Can someone tell me how I can take date information in a cell
such as
08/10/2005 and return only the day value such as 10?

Split mm/dd/yyyy into dd only
 

Custom format the cell containing the date to:

dd

OR ... custom format a cell that references the date cell.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"tomwashere2" wrote in message
...
Can someone tell me how I can take date information in a cell such as
08/10/2005 and return only the day value such as 10?

Split mm/dd/yyyy into dd only
 

Thank you. This is exactly what I needed to know.

"Chip Pearson" wrote:

Use the DAY function. E.g.,

=DAY(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"tomwashere2" wrote in
message
...
Can someone tell me how I can take date information in a cell
such as
08/10/2005 and return only the day value such as 10?