How to find the year from a given date

  • Thread starter Thread starter User
  • Start date Start date
U

User

I would like to know the formula by which we can find out the year from the
given dates
Eg; Date of Joining coloum has 10/01/97, 05/06/2001 so from this i should
get the year as 1997 and 2001...
Kindly suggest some formula to help me out for the desired output
 
just to expand on somewhat brief DB's response

you may go to Format->Cells-Custom and format yr cells as dd/mm/yy or
dd/mm/yyyy accordingly

THEN try to use the YEAR function

or use formula for text:

=IF(ISNUMBER(RIGHT(A1,4)*1),PRAWY(A1,4)*1,"")

David will surely come up with a more handy solution...

HIH
 
oops, sorry, David must have noticed that already

the formula should read as follows:

=IF(ISNUMBER(RIGHT(A1,4)*1),RIGHT(A1,4)*1,RIGHT(A1,2)*1)

sorry

and thank you David for the pointing-out
 

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

Adding 10 years to a date 2
Date Difference in Complete Tax Years 1
Calculating Dates Within Fiscal Year 2
YEAR MONTH DAYS COUNTER 3
Fiscal year calsulations for past to future dates. 6
Excel 2002 : How to sum by month and year ? 3
Calculate Date from a date 3
Date and years calculation 2

Back
Top