View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
user user is offline
external usenet poster
 
Posts: 44
Default How to find the year from a given date

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