Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Year from Dates
Hello,
How do I split the year from a date. Example I will need to extract 2/23 and leave out 1978. The purpose is so that viewers can not reformat the text to find out the year. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Year from Dates
=MONTH(A1)&"/"&DAY(A1)
Then you could Copy & Paste Special - Values but this will be text so no calculations are possible or, Maybe Hide column A best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mollas" wrote in message ... Hello, How do I split the year from a date. Example I will need to extract 2/23 and leave out 1978. The purpose is so that viewers can not reformat the text to find out the year. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Year from Dates
How do I split the year from a date. Example I will need to extract
2/23 and leave out 1978. The purpose is so that viewers can not reformat the text to find out the year. If dates are in column A, one way is to put this in B1 =IF(ISBLANK(A1),"",TEXT(A1,"m/yy")) and then copy down as far as needed. Then select column B id use Edit Copy Edit Paste special Values Then delete column A. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Year from Dates
This worked too! Thank you.
"MyVeryOwnSelf" wrote: How do I split the year from a date. Example I will need to extract 2/23 and leave out 1978. The purpose is so that viewers can not reformat the text to find out the year. If dates are in column A, one way is to put this in B1 =IF(ISBLANK(A1),"",TEXT(A1,"m/yy")) and then copy down as far as needed. Then select column B id use Edit Copy Edit Paste special Values Then delete column A. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting Year from Dates
Thank you. It worked!
"Bernard Liengme" wrote: =MONTH(A1)&"/"&DAY(A1) Then you could Copy & Paste Special - Values but this will be text so no calculations are possible or, Maybe Hide column A best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mollas" wrote in message ... Hello, How do I split the year from a date. Example I will need to extract 2/23 and leave out 1978. The purpose is so that viewers can not reformat the text to find out the year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting dates | Excel Discussion (Misc queries) | |||
Dates that need to be split into Year/MM/DD | Excel Discussion (Misc queries) | |||
Add one year to dates | Excel Worksheet Functions | |||
how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
dates in year | Excel Worksheet Functions |