Extracting the year from a date

  • Thread starter Thread starter DavidObeid
  • Start date Start date
D

DavidObeid

If I have a user enter a date into a date formatted cell (d/mmmm/yyyy),
how do I get the year to appear as an integer in another cell?

EG, if a user enters 25/11/2003 (say) in Cell B2, how would I go about
getting 2003 to appear as an integer in cell C2?

Non-vba solutions preferred since I am still a vbaidiot.

Thanks in advance,

Dave
 
=year(B2)

Ken Russell

|
| If I have a user enter a date into a date formatted cell (d/mmmm/yyyy),
| how do I get the year to appear as an integer in another cell?
|
| EG, if a user enters 25/11/2003 (say) in Cell B2, how would I go about
| getting 2003 to appear as an integer in cell C2?
|
| Non-vba solutions preferred since I am still a vbaidiot.
|
| Thanks in advance,
|
| Dave
|
|
| ------------------------------------------------
|
|
|
 
Back
Top