locked
Excel Dashboard RRS feed

  • Question

  • Hello all,

    I have a column header in excel as 

    1. Amount
    2. CashDiscountAmount
    3. CashDiscountDate
    4. CreatedDate
    5. InvoiceDate
    6. DueDate
    7. PostingDate
    8. Vendor name

    I have the data for the respective column.

    How do I calculate 

    1. Cash Discount utilized (Invoice trasferred before the cashdiscountdate)
    2. Cash discount lost (Invoice trasferred after the cashdiscountdate )
    3. paid late(Invoice posted after due date)
    4. open invoices per vendor





    Monday, December 21, 2020 10:19 PM

All replies