Thread: find a year in a string of dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carrie_Loos via OfficeKB.com Carrie_Loos via OfficeKB.com is offline
external usenet poster
  
Posts: 116
Default 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

Reply With QuoteReply With Quote