formula for calculating aging

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

I have a column for tracking the aging of projects but I only want it to show week days. Currently I have it set as "Today() - [Date Entered]" but how can I adjust it to only calculate week days?

Photo of Marci

Marci

  • 0 Points

Posted 4 years ago

  • 0
  • 1
no problem

Change your formula to be a formula numeric type and the formula to


WeekdaySub([Date Entered],Today() )

Note that if a Project is entered today it would be zero days old.  If you want to have that read as 1 day, then you would need to add 1.  It's the old fencepost problem - are you counting fences or fence posts.

WeekdaySub([Date Entered],Today()) +1


Photo of Marci

Marci

  • 0 Points
I entered this formula but it's showing negative numbers, any idea why?
Well because my formula was backwards, that is why!

WeekdaySub(Today(), [Date Entered])