Invoice template with early payment incentives

I am trying to build a feature into my invoicing template which reads some text from a cell under the heading “Terms” and prints either one of 2 dates, or a caption into the cell used for displaying the due date based on what is in the Terms cell without having to use 3 separate templates to work from.

The text I wish to use in the Terms cell will be one of the following
Cash, Standard or EPD, which stands for Early Payment Discount.

For cash, I’d like the Due date to be TODAY()+7

For Standard, I’d like the Due date to be =EOMONTH(TODAY(),0)+20

For EPD, I’d like the Due date to say “See Below”

Is this going to be possible?


assume cell “under heading Terms” is A2 then you may use:

=IFS(A2="Cash";TODAY()+7;A2="Standard";EOMONTH(TODAY();0)+20;A2="EPD";"See Below";A2="";"--- Terms not set---")

Tested using LibreOffice:

Version:, Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5;
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.

Thank you, that did the trick.