Convert day, month, year, and time to just year

Convert day, month, year, and time to just year

Post by bam » Sat, 21 Jul 2007 23:15:15


Hello, what formula can I use to convert day, month, year, and time values
to just a year

For example, what formula can I use to convert 4/16/2002 12:59pm to simply
2002 or 1/1/2002.

bmac
 
 
 

Convert day, month, year, and time to just year

Post by Bob Philli » Sat, 21 Jul 2007 23:22:34

=YEAR(A1)

or just format the cell as YYYY to se ethe year but retain the value

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 
 
 

Convert day, month, year, and time to just year

Post by bam » Sat, 21 Jul 2007 23:59:42

Thasnks for responding ... I still must be doing something wrong ...

In E2 I have the date 6/20/2001 12:25pm and then enter in H2 ... =YEAR(E2)
and I get the value 6/23/1905.

Any ideas?
 
 
 

Convert day, month, year, and time to just year

Post by Dave Peter » Sun, 22 Jul 2007 00:16:36

Format it as General (or number)--just not a date.







--

Dave Peterson
 
 
 

Convert day, month, year, and time to just year

Post by bam » Sun, 22 Jul 2007 00:26:50

Thanks very much!
 
 
 

Convert day, month, year, and time to just year

Post by Bob Philli » Sun, 22 Jul 2007 01:17:00

I'm just your patsy aren't I? I lead with a half-volley, and you smash the
winner <g>

Do you play tennis?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
 
 

Convert day, month, year, and time to just year

Post by Dave Peter » Sun, 22 Jul 2007 01:26:09

Maybe you can lead the league in assists!












--

Dave Peterson