Count number business days per month
조회 수: 2 (최근 30일)
이전 댓글 표시
19630102
19630103
19630104
19630107
19630108
19630109
19630110
19630111
19630114
19630115
19630116
19630117
19630118
19630121
19630122
19630123
19630124
19630125
19630128
19630129
19630130
19630131
19630201
19630204
19630205
19630206
19630207
19630208
19630211
19630212
19630213
19630214
19630215
19630218
19630219
19630220
19630221
19630225
19630226
19630227
19630228
Good evening,
I have a set of data like the one shown in the figure below (but the complete set of data goes until 2013), which represent already the business days in that month.
I would want a column that counts the number of days per month and gives me, for instance, 22 in row 1 (for January), 19 in row 2 (for February) and so on.
Thank you!!
댓글 수: 2
Azzi Abdelmalek
2014년 4월 26일
편집: Azzi Abdelmalek
2014년 4월 26일
date is numeric or char? and instead of posting an image, copy and past your data,in away we could use it
답변 (1개)
Azzi Abdelmalek
2014년 4월 26일
편집: Azzi Abdelmalek
2014년 4월 26일
n=max(0,fix(log10(data)+1)-6)
b=fix(data./10.^n)
c=unique(b);
f=histc(b,c);
q=uint8(rem(c/100,1)*100);
p=arrayfun(@(x) datestr(datenum(num2str(x),'mm'),'mmm'),q,'un',0);
out=[p num2cell(f)]
참고 항목
카테고리
Help Center 및 File Exchange에서 Dates and Time에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!