5 Replies Latest reply: Sep 18, 2013 11:33 AM by Rodrigo Morales RSS

    AVG of Dates

    Rodrigo Morales

      How can I get the AVG between the day the bill come and the day we paid the bill?


      I make this:  =num(avg(day(DatePaymentBill-DateReceptionBill)), '##,##')


      But I have a problem, sometimes we paid before the bill come (like a prepayment) and other times we paid after the bill come. So I wanna make 2 text object with this average.