| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count numbers of Month in a cell
Dear All:
Please help I have put this formulas to count the times of Months =SUMPRODUCT((MONTH(B6:B1613)=1)*(YEAR(B6:B1613)=20 09)*(INT(B6:B1613) <INT(B7:B1614))) but the result skip the duplicate date, how to solve this problem please kindly help. Thanking you in advance for kind help in this matter. NM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count the occurrences of a month in a date&time cell | Excel Worksheet Functions | |||
| Count duplicate cell values per month | Excel Worksheet Functions | |||
| Function to count numbers in one Cell IE 1+2+10 | Excel Worksheet Functions | |||
| How do I add/count numbers in the same cell in excel worksheet? | Excel Worksheet Functions | |||
| Count a numbers of entries in a given month ? | New Users to Excel | |||
Threaded Mode
