Matching based on working days
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
Clay Swackhamer
2019-4-8
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.
采纳的回答
Rik
2019-4-8
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 个评论
Rik
2019-4-8
As a sidenote, the functions in this answer all support datetime inputs as well, despite the doc for weekday not mentioning this.
更多回答(1 个)
Steven Lord
2019-4-8
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!