| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Killing the split window | Setting up and Configuration of Excel | |||
| Enable a new dimention: sub-level of split cells | Excel Discussion (Misc queries) | |||
| How do I split the y-axis scale on a chart? | Charts and Charting in Excel | |||
| How do I split a single cell in Excel ? | Excel Discussion (Misc queries) | |||
| split a single column into 2 separate columns | Excel Worksheet Functions | |||
Linear Mode
