Excel Formula

J

JG

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When building a chart Dates are been included that are not in thedate range 1
2 dimensional date sort 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Adjusting Timeline with a link 5
how to create a formula with expiry condition 2
index_match 5
How to write XIRR formula on excel using different Year basis than 365. 5
IF condition using GMT and BST times 4

Top