I have a list of dates running down column B.
ie.
14th July 2008
22nd July 2008
12th August 2008
26th August 2008
I need a formula that counts only the months i want (ie. just count amount of times a date in july occurs)
Any help would be great!
Thanks
Last edited by VBA Noob; 06-30-2008 at 03:36 PM.
Hi and welcome to the boardOriginally Posted by BodyHaven
TryAdjust the range to your needs=sumproduct(month(a2:a10)=7)
Cheers
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Thanks very much!
I tried this formula and it doesnt work?
I assume the "month" part stays as is and that the "7" represents July!?
Does my date need to be in a particualar format? The dates are formated to dates already
Also how would i specify the month and year i want to add (ie. to add july 2007 not july 2008)
Many Thanks
If it makes a difference, it is for Excel 2007
Don't think it's important .If it makes a difference, it is for Excel 2007
Sorry,I wasn't really watching, but I suppose 14th July 2008 is text or is it a date with a Custom format ? (if you're not sure right-click the date and select format, then Number ( don't OK)If it reads a number it's a date, if not it's plain text).
What error did you get ?
Last edited by arthurbr; 06-30-2008 at 04:17 PM.
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Its a custom date (DD MMM Y)
I dont get an error, it just doesnt count them. Cant get anything but zero
Could you please post a small sample of your data (see "attachments" under 'additional options") ?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
I put it onto a new sheet for clarity
Hi,
I took the liberty of changing a year to check.
Added a file with a formula and a PT approach
Is this what you need?
Cheers
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks