display a year

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

Hello everyone, I have a spreadsheet showing, amongst other things,
date of birth and date of attendance for each customer.

Say the date of birth is in B2 and the date of attendance is in C2 etc
Column D then calculates the age on attendance and column E calculate
if the customer is under 16.

What I want in column F is a formulae to display the year of birth, i
this possible? If I do a (RIGHT(.....) formulae it displays the numbe
value behind the value and not 1972 etc etc.

ANy help welcome.

Cheers

Scott
 
Hi Scott!

One way:

=YEAR(B2)

This returns the year as a number.

Another:

=B2
Custom Format yyyy

This returns the date in B2 but it is formatted to show the year only.

And another:

=TEXT(B2,"yyyy")

This returns the year of the date in B2 but as a text entry (not used
much for year but common to get the month returned as text).
 

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

Calculating age from date of birth and ignoring if blank 5
Count/Calculation According to Age of the Person 1
Completed years and monhts 6
Accumulating Attendance Base upon Age Group 5
Combine two spreadsheets into one 3
Excel - Calculate age from DOB in years, months days 7
How do I calculate a persn's age in years & months in Excel? 4
Date Formula 85 factor 7

Back
Top