How to calculate only weekdays

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

If(IsNull([MIROR_UPDATE_COMP]),ToDays(Today()-[STATUS_PENDING_MIROR_DATE]))


Both fields are Date Fields

                  

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
I believe this will work 

If(IsNull([MIROR_UPDATE_COMP]),WeekdaySub(Today(),[STATUS_PENDING_MIROR_DATE]))