I'd like to create a date variable that is based on the number of trading days from an event date. For instance, the event date is 1/2/2024, I'd like to create a date for 100 trading days from 1/5/2025. Roughly speaking, trading days are week days plus the following holidays: Third Monday of January — Martin Luther King Jr. Day Third Monday of February — Presidents' Day Last Monday of May — Memorial Day June 19 — Juneteenth July 4 — Independence Day First Monday of September — Labor Day Fourth Thursday of November— Thanksgiving Day Dec. 25 — Christmas Day I understand I can do newdate=intnx('weekdays',olddate,100) to count only week days. But how can I also account for(exclude) the above holidays? Thank you! Attached is sample of data with old dates that I'd like to calculate the new dates on. Thank you!
... View more
