Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date function
Hi,
I have a date in a field 03/25/2006...I would like to change this date to only show day and month of date 03/25 . I think I can use the Day and Month functions to pull out the day and month from the date. Can someone help me with using one fuction to get day and month from this date field. Thanks for you help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date function
Natalie,
You could just re-format your cells with the date in. Select the cells Open up the format cells dialog (will vary depending on your version of Excel) Select 'Custom' from the list of formats. In the 'Type' line, type in 'mm/dd' (without quotes) Now no matter what date you tyoe in you will only get the month and day. HTH Neil www.nwarwick.co.uk "Natalie" wrote: Hi, I have a date in a field 03/25/2006...I would like to change this date to only show day and month of date 03/25 . I think I can use the Day and Month functions to pull out the day and month from the date. Can someone help me with using one fuction to get day and month from this date field. Thanks for you help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |