Matching based on working days
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Clay Swackhamer
le 8 Avr 2019
What kind of data type is your date vector? If this is text stored in a cell we might want to consider converting to a datetime object. Otherwise if it is already a datetime object then you could use some built in features for those objects. You could find out in your code by running
whos A
in the command window.
Réponse acceptée
Rik
le 8 Avr 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 commentaire
Rik
le 8 Avr 2019
As a sidenote, the functions in this answer all support datetime inputs as well, despite the doc for weekday not mentioning this.
Plus de réponses (1)
Steven Lord
le 8 Avr 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.
Voir également
Catégories
En savoir plus sur Calendar dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!