| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a year in a string of dates
I have a column of dates that span across several years in column C (1/2/2009)
format and I have hours to complete the project in column Q. I want to make a cell, A21, where the user can input a year (2009) and pull all the data for that year which is the first part of the formula below but I can't seem to get it to recognize just that year. I have tried a combination of different things but without success. Can someone see the error of my ways?? =IF('Hours Worksheet'!$C$4:$C$1464=$A$21,SUMIF('Hours Worksheet'!$D$4:$D$1464, 26,'Hours Worksheet'!$Q$4:$Q$1464),0)) Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200905/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Year from a text string | Excel Worksheet Functions | |||
| Find String in another string - only between spaces | Excel Worksheet Functions | |||
| Find Many String options in ONE String | Excel Worksheet Functions | |||
| I need to find out the YEAR, MONTH, DAY between two dates | Excel Discussion (Misc queries) | |||
| how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
Threaded Mode
