| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a year in a string of dates
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message news:95a460c0a0c5c@uwe... It works, Thanks! I guess I need to practice with the SUMPRODUCT formula some more...:) T. Valko wrote: Try this: =SUMPRODUCT(--(YEAR('Hours Worksheet'!$C$4:$C$1464)=$A$21),--('Hours Worksheet'!$D$4:$D$1464=26),'Hours Worksheet'!$Q$4:$Q$1464) I have a column of dates that span across several years in column C (1/2/2009) [quoted text clipped - 12 lines] 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
