Dates

M

Michael

Hi I have a series of birth dates and I only need the year is there any way
to strip the excess information from the cell?

Many thanks

Michael
 
R

Ron Rosenfeld

Hi I have a series of birth dates and I only need the year is there any way
to strip the excess information from the cell?

Many thanks

Michael
Click to expand...

Look at the YEAR worksheet function.

--ron
 
Top