Excel Formula
 

I have a row of dates i.e., 03-Mar-07, 04-Apr-08, 02-Feb-07, 11-Nov-08...and
I want to COUNTIF all dates in '08' (for instance)...regardles of day and
month...how do I write the formula...thank you

Excel Formula
 

something like

=Sumproduct(--(Year(A1:Z1)=2008)

adjust range as necessary.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125036

Excel Formula
 

=SUMPRODUCT(--(YEAR(1:1)=2008))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JG" wrote:

I have a row of dates i.e., 03-Mar-07, 04-Apr-08, 02-Feb-07, 11-Nov-08...and
I want to COUNTIF all dates in '08' (for instance)...regardles of day and
month...how do I write the formula...thank you