sumif, countif, datedif formula
The below will return the number of entries of year 2007.
=SUMPRODUCT(--(YEAR(K3:K1408)=2007))
If this post helps click Yes
---------------
Jacob Skaria
"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
|