Hi guys,
Can someone give me information about how I can automatically calculate the "remaining business days" field from now to the project ending date, excluding weekends and company closed days(like national holidays and etc)?
I also want this filed to be recalculated and updated everyday automatically.
I am calculating and updating "remaining calander date" field by "DiffInDays(Now(), new_duedate)" function but I couldn't find a way to exctract weekends and other holidays.
Thanks for the help
Mert
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156