Home |
Search |
Today's Posts |
#1
|
|||
|
|||
removing year from date
I have several dates listed as mm/dd/yyyy. How do I remove the year
automaticall from a long list? I do not mean that I want to format the cell to just show me the month and day, I want to actually remove the year data from the column not just hide it. Thank you. |
#2
|
|||
|
|||
On Sun, 11 Sep 2005 11:05:06 -0700, "Joe Man"
wrote: I have several dates listed as mm/dd/yyyy. How do I remove the year automaticall from a long list? I do not mean that I want to format the cell to just show me the month and day, I want to actually remove the year data from the column not just hide it. Thank you. If it is going to be a value that Excel recognizes as a date, it must include a year. Excel stores dates as serial numbers beginning with 1 = 1/1/1900 (or 1904). So there is no way to "remove the year" and have Excel still recognize this value as a "date". If you just want the Month and Day, and don't want a year in the cell, then you cannot store it as a serial number and have Excel convert it to a date. You could change it to a TEXT string of mm/dd: =TEXT(A1,"mm/dd") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Day number of given date in a year | Excel Worksheet Functions | |||
dHow do I put in the date without the year? | Excel Discussion (Misc queries) | |||
Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions |