View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
v1rt8 v1rt8 is offline
external usenet poster
 
Posts: 34
Default sumif, countif, datedif formula

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