MATLAB Answers

Matching based on working days

6 views (last 30 days)
Wesso
Wesso on 7 Apr 2019
Commented: Wesso on 9 Apr 2019
Hi,
I have a vector A of dates and I want to create a vectors of working days that are 1 day prior, 1 week prior and 4 week prior to vector A dates.
How can I do so?
  3 Comments
Wesso
Wesso on 8 Apr 2019
My vector is serial matlab date numbers. I had excel dates and transferred them to matlab using x2mdate.
I tried
B=A-1;
C=A-4;
D=A-28
But some of the days were saturdays and sundays. I posted the question in order to produce them neatly. Otherwise,I will use a loop to say that if the date is Saturday use Friday date, if it is a Sunday use Monday...

Sign in to comment.

Accepted Answer

Rik
Rik on 8 Apr 2019
You can use the weekday function. You can easily adapt the function below to apply specific shifts.
A=datenum({'2019-04-07','2019-04-08','2019-04-06'});
B=A-1;
C=A-4;
D=A-28;
B=move_to_workday(B);
C=move_to_workday(C);
D=move_to_workday(D);
function A=move_to_workday(A)
%shift sat to fri, sun to mon, and leave the rest
% %option 1:
% isSunday=weekday(A)==1;
% isSaturday=weekday(A)==2;
% A(isSunday)=A(isSunday)+1;
% A(isSaturday)=A(isSaturday)-1;
%option 2:
shift=[1 0 0 0 0 0 -1];
%shift(weekday(A)) retains the shape of shift, instead of taking on the
%size of A, hence the reshape
A=A+reshape(shift(weekday(A)),size(A));
end
  1 Comment
Rik
Rik on 8 Apr 2019
As a sidenote, the functions in this answer all support datetime inputs as well, despite the doc for weekday not mentioning this.

Sign in to comment.

More Answers (1)

Steven Lord
Steven Lord on 8 Apr 2019
If possible, switch to using datetime instead of serial date numbers. You can use the datetime options 'ConvertFrom', 'excel' or 'ConvertFrom', 'excel1904' to create the datetime array from the Microsoft Excel data.
If you use datetime you can use day (with the 'dayofweek' KIND input), isweekend, and/or dateshift.
D = datetime('today');
dayName = day(D, 'name')
dayCode = day(D, 'dayofweek')
isweekend(D) % As I write this it is Monday so this returns false
sundayBefore = dateshift(D, 'start', 'week')
isweekend(sundayBefore) % This returns true
If you want to go further with your classification of working days than just "weekday or weekend", the holidays function in Financial Toolbox accepts datetime as inputs.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by