why is aging column showing negative number?

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

I am using the numeric formula of: 

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

but it is showing negative numbers. How can I have it show positive numbers?

Photo of Marci

Marci

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QB_Support_Brian

QB_Support_Brian

  • 20 Points
Hi Marci,

The function WeekdaySub(Date d2, Date d1) returns the number of weekdays in the interval starting with d1 and ending on the day before d2. This means that, if the Date Entered in your formula is in the past, you may see a negative number as a result. If you want to just see the number of days regardless, without the minus sign, you can take the absolute value of the # of days instead:
Abs(WeekdaySub([Date Entered],Today()) +1)


Thanks,Brian