| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to transform the dates to months
I need help with a formula that will lookup the dates into months.
For example, if I have a set of dates in a column: 01/15/07 == Jan '07 02/05/07 == Feb '07 02/13/07 == Feb '07 01/05/06 == Jan '06 04/25/06 == Apr '06 I need a formula that will switch them to the month and year that the date is within that month and year. Thanks, D |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to transform the dates to months
Format cells as: mmm-yy
or =TEXT(A2,"mmm-yy") "dereksmom" wrote: I need help with a formula that will lookup the dates into months. For example, if I have a set of dates in a column: 01/15/07 == Jan '07 02/05/07 == Feb '07 02/13/07 == Feb '07 01/05/06 == Jan '06 04/25/06 == Apr '06 I need a formula that will switch them to the month and year that the date is within that month and year. Thanks, D |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to transform the dates to months
One way ..
With source dates in A1 down (assumed to be real dates) Then in B1: =TEXT(A1,"mmm 'yy") Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "dereksmom" wrote: I need help with a formula that will lookup the dates into months. For example, if I have a set of dates in a column: 01/15/07 == Jan '07 02/05/07 == Feb '07 02/13/07 == Feb '07 01/05/06 == Jan '06 04/25/06 == Apr '06 I need a formula that will switch them to the month and year that the date is within that month and year. Thanks, D |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to transform the dates to months
Use a custom format of mmm yy, or if you want text use
=TEXT(A1,"mmm yy") -- Regards, Peo Sjoblom "dereksmom" wrote in message ... I need help with a formula that will lookup the dates into months. For example, if I have a set of dates in a column: 01/15/07 == Jan '07 02/05/07 == Feb '07 02/13/07 == Feb '07 01/05/06 == Jan '06 04/25/06 == Apr '06 I need a formula that will switch them to the month and year that the date is within that month and year. Thanks, D |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to transform the dates to months
If you want to change the existing dates then re-format them to Custom
Fromat mmm yy or if you want the apostrophe as well use mmm 'yy But this shows as with the apostrophe hard up agains the zero so you might want to include a space: mmm ' yy -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "dereksmom" wrote in message ... I need help with a formula that will lookup the dates into months. For example, if I have a set of dates in a column: 01/15/07 == Jan '07 02/05/07 == Feb '07 02/13/07 == Feb '07 01/05/06 == Jan '06 04/25/06 == Apr '06 I need a formula that will switch them to the month and year that the date is within that month and year. Thanks, D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how many months and days between two dates? | New Users to Excel | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Number of months between 2 dates | New Users to Excel | |||
| Need More Help on Dates to Months | Excel Worksheet Functions | |||
Linear Mode
