Ricardo Hernandez - No Longer at Nielsen Posted June 17, 2019 Share Posted June 17, 2019 I was able to add a calculated column to remove weekends for a date range but I would like to take out U.S. holidays if they are present. Below are some dates I'm working with. Can anyone help with this calculation dateAssigned shippedDate ShippingTime ship_NoBusinessDays [need]shipDays_NoBusinessNoHolidays 12/14/2018 1/11/2019 28 20 10/24/2018 1/15/2019 83 59 12/5/2018 1/18/2019 44 32 TIA, Rick Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted June 18, 2019 Share Posted June 18, 2019 Hello Rick, You will have to manually add the conditions for each holiday in the calculated column's expression. For example, if today is 18th June 2019 and 1st of June was a holiday then you can modify your calculated column expression as: Your custom expression to drop weekends OR[Date Column] dateadd('dd',-17,Date('6/18/2019')) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now