Extracting the year from a date

[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

 

[Ken Russell]

=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
|
|
| ------------------------------------------------
|
|
|

 

[Kieran]

in c2 enter =year(b2)

Kiera

 

[DavidObeid]

Thanks.

Ya gotta love simple solutions.

 

[pfsardella]

In C2,

=Year(B2)

HTH
Paul

 

[Guest]

In C2, enter =year(b2)