如何在Google Sheets中根据付款条款自动调整到期日期（解决“收到即付”场景计算问题）

Hey there, great job getting the NetX terms working already! To fix the "收到即付" (Pay Upon Receipt) scenario, we just need to add a simple conditional check to your formula. Here's the updated version you can drop into your first due date cell (e.g., D2):

=IF(C2="收到即付", B2, B2+RIGHT(C2,2))

Breakdown of how this works: #

• Conditional Check: The IF function first verifies if the payment term in cell C2 is exactly "收到即付". If that's true, it returns the original date from B2—since payment is due immediately when received.
• NetX Term Handling: If the term isn't "收到即付", the formula uses your original logic: it grabs the rightmost 2 characters from the payment term (which gives the number of days to extend) and adds that to the original date in B2. This works for both "Net30" (no space) and "Net 15" (with space) formats perfectly.

Sample Output for Your Data: #

Applying this formula to your table will give you these correct due dates:

Just drag the formula down the column, and it’ll handle all your payment term scenarios automatically.

内容的提问来源于stack exchange，提问作者Karan Singh