How to use a right formula on a date-format

  • Thread starter Thread starter Heine
  • Start date Start date
H

Heine

Hi everybody,

My problem is this. I have a lot of cells containing dates 06-06-2006
etc. They are in a date format. I want the next column to only return
the year i.e. 2006 in the above exampel. I tried the right formula -
but that only returns the corresponding number (corresponding to the
date) - any ideas?

Regards
Heine
 
Use =YEAR(A1) rather than =RIGHT(A1,4). If you want to use RIGHT then you
must also use TEXT.
 
You are very welcome!

The alternative is:
=RIGHT(TEXT(A1,"mm/dd/yyyy"),4)
 
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

Return Numeric Values Matching EXACT Date for Criteria 4
help with format change of date part of concatenate formula 1
changing date formats 4
Using Index and Match Formula 2
date formula 6
Picking out a Period, in relation to certain cells 6
need help splitting a name form a date 3
Allocate an income payment over a date range (tax years) 7

Back
Top