Formula for Payment Terms "Net 10 EOM"

Genevieve P.

Hi @ksieverding

Can you explain what it is you're looking to do? There is no day-of-month that's 120. Are you wanting to have a date return that 120 days after a specific date?

If so, you can simply add 120 to the date! 🙂

=[Date Reference]@row + 120

See: https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

If this isn't what you were looking to do, the new Formula AI tool is available to all users until December! I would recommend trying this out. Here's the announcement post: For a limited time - AI access for the AI curious. Start benefiting now!

Cheers,
Genevieve