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?