copy date in a cell if within a date range
 

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

copy data in a cell if within a date range
 

"carrerapaolo" wrote:

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

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