11 Replies Latest reply on Oct 11, 2019 2:30 PM by Subodh Gupta

    Weekdays left in month from Today

    Mansi Soni

      Hi everyone,

       

      Is there a formula to calculate WEEKDAYS left in the month from today.

       

      I am able to get "days left to the month from today", with the following formula but it includes weekends. I don't want weekends.

       

      DATEDIFF("weekday",[Today], dateadd("weekday", -1, dateadd("month", 1, DATETRUNC("month",[Today]))))

       

      Any help is truly appreciated.

       

      Thanks!

      Mansi