53 Replies Latest reply: Feb 3, 2017 5:15 AM by Sunny Talwar RSS

    Counting working days this week / month

    Ali Ahmad

      So in an excel sheet there is a column called "Days this week" which counts:


      Monday as 1,

      Tuesday as 2,

      Wednesday as 3


      (only Mon-Fri)


      ++


      And another column called Days This Month that also works as a counter of working days from the first day of the month as 1, second as 2 etc. and want this to automatically be done for each month.


      I want to create these fields based on a budget date.


      I've heard about "Network" days, but not sure how to get to this.


      Any tips anyone?