Hi,

I need to evaluate data based on date but, unfortunately, the string that I
have to work with is as follows:

4/3/2006 13:22

I'm not concerned with the time stamp. I need to reduce it to 4/3/2006 and
then be able to seperate out the day, month and year. This is so I can show
'X' amount of items in a year, in a month, etc.

I've done this before but it's always been a bit tedious.

I can change the format of the cell to Day-Month-Year but the time stamp
remains which causes problems with calculations.

Is there an easy way to get rid of the time stamp and seperate out the
calendar items?

If there are 150 to 300 of these items entered in any given year and I want
to view just the year, it's a HUGE pain to have to put them into a pivot
table and uncheck the years or months I don't want!

Thanks in advance!