I Wish to generated a date matrix.

Hello,

How can I generate a date matrix in which I know the start date let say end of last month (03/31/2012) and I know the frequency say each month end and I know how many rows I want let say 100 rows. than mean size of the matrix will be (100,1).

if the frequency is weekly then how will we generate the date matrix.

Thanks jas

Answer 1

[Andrei Bobrov]

n = 100;
DateMat = datemnth('03/31/2012', (0:n-1)');

OR:

DateMat = datenum(2012,4+(0:n-1)',1,0,0,0)-1;

[Jas Gil]

Thank you very you saved my life.

gil

[Jas Gil]

Hi Andrei,

if the frequency is weekly then how will we generate the date matrix.

Thanks fo your earlier solution it work very well

gil

Answer 2

[Walter Roberson]

Unfortunately this is not as vectorizable as one might hope. If, however, you apply the change I just posted http://www.mathworks.com/matlabcentral/answers/36444-eomday-extension-for-wrapping-month-numbers then you could use

n = 100;
DateMat = datenum([2012*ones(n,1), 3:3+n-1, eomday(2012,3:3+n-1).']);

Warning: this will not work with the Mathworks-provided eomday!