View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default sumif, countif, datedif formula

On Sun, 24 May 2009 10:21:01 -0700, v1rt8
wrote:

K3:K1408 contain dates of hire i.e. 4/30/2007
would like to count how many were hired in year 2007, 1999, etc.. how what
would be the formula, is it a nested formula? at a loss. really do not want
to make a separate column just to provide the year then do a countif column.
thanks for help


You can use COUNTIF also:

For 2007, something like:

=COUNTIF(K3:K1408,"="&DATE(2007,1,1)) - COUNTIF(K3:K1408,""&DATE(2007,12,31))
--ron