software

I'm trying to manipulate a large number of dates for sorting. I only need
the year, but the data base has MMDDYYYY in it. I want to end up with YYYY
only for a new sort.If the dates are actual Excel dates, just formatted as MMDDYYYY,
use the YEAR function to get the year. E.g,

=YEAR(A1)

If the dates are not actual Excel dates, use the RIGHT function
to get the last for characters. E.g.,

=RIGHT(A1,4)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Bill Rquot; lt;Bill gt; wrote in message
...
gt; I'm trying to manipulate a large number of dates for sorting.
gt; I only need
gt; the year, but the data base has MMDDYYYY in it. I want to end
gt; up with YYYY
gt; only for a new sort.
gt;