Effacer les filtres
Effacer les filtres

remove weekends and holidays data from excel file

3 vues (au cours des 30 derniers jours)
MUKESH KUMAR le 15 Jan 2019
Réponse apportée : KSSV le 15 Jan 2019
I had excel file ABC.xlsx, in which sheet A having data from date 01-04-2017 to 31-12-2018 and the sheet2 having the list dates which are holidays( holiday may be fall on weekends). So now I want to create a another excel to seprate the weekdays and weekends/holidays data???

Réponse acceptée

KSSV le 15 Jan 2019
% Read data
T1 = readtable('ABC.xlsx','sheet',1) ;
T2 = readtable('ABC.xlsx','sheet',2) ;
% Get dates common in both
idx = ismember(T1.(1),T2.(1)) ;
% Pick which are not common
T = T1(~idx,:) ;
% write to a file

Plus de réponses (0)


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!

Translated by