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.