Counting days by month

6 visualizaciones (últimos 30 días)
dan berkowitz
dan berkowitz el 22 de Oct. de 2017
Comentada: Andrei Bobrov el 23 de Oct. de 2017
hi,
i have a 100x11 char array with dates (e.g. '03-Jan-2006'). how can i create an array with the number of days in each unique month that appear in my date array. (e.g. if i have two days in january 2006, then i want it to return 2). any help would be appreciated. thx in advance.
DB

Respuesta aceptada

Andrei Bobrov
Andrei Bobrov el 22 de Oct. de 2017
Editada: Andrei Bobrov el 22 de Oct. de 2017
Here A - your array "100x11 char array with dates (e.g. '03-Jan-2006')"
z = datetime(A);
T = table(datetime(z,'F','MMM-uuuu'),eomday(year(z),month(z)),'v',{'date','days'});
  4 comentarios
dan berkowitz
dan berkowitz el 23 de Oct. de 2017
Thank you! I didn't know about the ymd function! Appreciate your help.
Andrei Bobrov
Andrei Bobrov el 23 de Oct. de 2017
[y,m] = ymd(z);
or
[y,m] = datevec(z);

Iniciar sesión para comentar.

Más respuestas (1)

KL
KL el 22 de Oct. de 2017
Editada: KL el 22 de Oct. de 2017
It's better to change your char array into datetime vector
dt_array = datetime(char_array,'InputFormat','dd-MMM-yyyy')
and then you can use
numOfDays = nnz(dt_array.Month==your_month)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by