| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| If date in cell falls between date range... | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
Linear Mode
