View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default copy date in a cell if within a date range

=IF(YEAR(A3)=2010,M3,"") is the formula to use in T3
--
David Biddulph


"carrerapaolo" wrote in message
...
Column M is a listing of percentages

Column A is various dates, anywhere from Jan 1, 1998 to the present.

I need to copy the contents of let's say M3 into cell T3 is the date in
cell
A3 is any date in the year 2010. If the date is in another year, leave
cell
T3 blank

Thanks