Dates

  • Thread starter Thread starter Michael
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year formula 4
date formulas 9
How do I calculate a person's age from date of birth and a date 2
Date Reformating Question 2
Date and years calculation 2
How to move data from rows to columns 6
Convert date to Age 3
Using Year of Birth, from DOB, in later calculations 5

Back
Top