Hi,
Can someone suggest a formula for counting the number of occurences of a month & year in a date column?
The spreadsheet is looking at items raised in any given month e.g. all items raised in Dec-08.
Many thanks,
Hi,
Can someone suggest a formula for counting the number of occurences of a month & year in a date column?
The spreadsheet is looking at items raised in any given month e.g. all items raised in Dec-08.
Many thanks,
Last edited by RamboDanbo; 12-15-2008 at 04:31 PM.
Try
=SUMPRODUCT(--(TEXT(A1:A100,"mmm-yy")="Dec-08"))
perfect! many thanks for that!![]()
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks