Calculating combinations of dates with empty cells

Dear all,

I have the following cell vector of dates

jji= ' '

   '28/12/08'

   '25/01/09'

that corresponds to the cell vector of values

values

 ''

 [0.6034]

 [0.5943]
 [0.4567 ]

and I want to create the following new vector of values

 ''

(28*0.6034+3*0.5943)/31

(25*5943+6*0.456)/31

where in the second row of this vector the numerator (28*0.6034+3*0.5943) is the sum of two products.

In the first product which is 28*0.6034 the number 28 is actually the first two digits from '28/12/08'

In the second product which is 3*0.5943 the number 3 is actually the distance in days between 28/12/08' and the end date of that month, that is the difference '28/11/08-31/11/08

The denominator in the second row (31) is the total number of days for month November 2008

Similar analysis holds for the last raw.

In my previous question Andrei gave a very nice code that worked for the case that I do not have empty cells.

That is,

 clear all

clc

jji={ '23/11/08' 

      '28/12/08' 

      '25/01/09'};

values ={

   0.5637

   0.6034

   0.5943

   0.4567 };

[Y M D] = datevec(jji,'dd/mm/yyyy');

ED = eomday(Y, M);

n = numel(values);

   awe=cell2mat(values(hankel(1:n-1,n+[-1 0])));

   out = sum([D, ED-D].*awe,2)./ED;

How could I modify that code for the case of empty cells?

thanks

[Jan]

Please format your code.

[antonet]

I was trying to find a solution.

One way is to replace the empty cell with the value zero, then apply the above code and then create again the empty cell as follows:

clear all

clc

jji={ ' '

    '28/12/08' 

    '25/01/09'};

values ={

 ' '

 0.6034

 0.5943

 0.4567 };

%create fake dates and values

jji{1,1}='01/01/01'

values{1,1}= 0

%application of the previous code

[Y M D] = datevec(jji,'dd/mm/yyyy');

ED = eomday(Y, M);

n = numel(values);

 awe=cell2mat(values(hankel(1:n-1,n+[-1 0])));

 out1 = sum([D, ED-D].*awe,2)./ED;

out1=num2cell(out1)

%create again an empty cell

 out1{1,1}=''

Is there any better approach?

Thanks again

[antonet]

Sorry. I do not understand what "format your code" means? Should I change something in the display of the code?

thanks

[antonet]

Am I doing something wrong with the code that I displayed?

[antonet]

Is there a better approach?. If not, it is ok. I just need to know if there is space for further improvement of the code.

thank you

[Walter Roberson]

http://www.mathworks.com/matlabcentral/answers/13205-tutorial-how-to-format-your-question-with-markup

[antonet]

Is it ok now?

 clear all
clc
jji={ '23/11/08' 

      '28/12/08' 

      '25/01/09'};
values ={

   0.5637

   0.6034

   0.5943

   0.4567 };
[Y M D] = datevec(jji,'dd/mm/yyyy');
ED = eomday(Y, M);
n = numel(values);

 awe=cell2mat(values(hankel(1:n-1,n+[-1 0])));

   out = sum([D, ED-D].*awe,2)./ED;

[antonet]

 is there a better approach?

Thank you very much