Hi Guys, I use this code to get the date of Monday and Friday from previous week - %let first_day=%sysfunc(intnx(week.2,%sysfunc(today()),-1,b),date9.); %put first_day=&first_day ; %let last_day=%sysfunc(intnx(week.6,%sysfunc(today()),0,b),date9.); %put last_day=&last_day ; The macro is usable for most weeks, except when there's a holiday on Monday or Friday. How can I get the next working day if there's a holiday on Monday and previous working day if it is a holiday on Friday?
... View more