Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Nr of days excluding weekends

Hi guys,

Hi Guys. I need to add 13 days to the current date to get the projected date. How can i exclude the weekends?

For example today's date is 02/27/14 and I want to add 13 days to it. by not excluding weekends I get 3/12/2014 While I needed to exclude weekends and the date should look like: 03/18/2017

Thank you in advance!

1 Solution

Accepted Solutions
Nicole-Smith

=lastworkdate(today(),14)

View solution in original post

2 Replies
Nicole-Smith

=lastworkdate(today(),14)

alec1982
Specialist II
Specialist II
Author

Thank you so much!