Share via

Payment Schedule

Anonymous
2024-12-03T18:21:52+00:00

Hi,

I need a formulae in the cells below months' column to calculate amount due in the month otherwise 0

Dec-24 Jan-25 Feb-25 Mar-25 Apr-25
Payment term 30% advance, 20% upon shipment and 50% on arrival
Order date 15/12/2024
Days from order to shipment 45
Days from shipment to arrival 15
Order value 1,000,000.00
Order currency US$
Advance payment 30%
Second payment 20%
Third payment 50%

* Changed to a question.

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2024-12-04T04:13:46+00:00

    Hi TarigE,

    Thanks for visiting Microsoft Community.

    If the dates in the date column represent some kind of payment date and you need to pay off the costs before that date in one go, I don't think there's anything that requires formula calculation.

    You just need to calculate the exact shipping and receiving dates to know when to make the payment. From the results, the shipping date is January 29, 2025, and the receiving date is February 13, 2025. This means that on December 24, you need to pay a prepayment of 300,000, and on February 25, you need to pay a total of 700,000 for the shipping and receiving costs. The amounts for the other dates are all zero.

    If you can provide a more detailed explanation of the data, I might be able to offer more formula-related suggestions.

    Best Regards,

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest