Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How can I calculate invoice due date based on invoice issued date + 30 days

Topic Labels: Formulas
Jump to Solution
194 2
Showing results for 
Search instead for 
Did you mean: 

Hi I would like to add a formula field which calculates when an invoice is due for payment. I have an ‘invoice issued’ date field and would like to use that to calculate +30 days.
this is where I have got to but its returning an error

DATEADD({Date Invoice Raised} +30,‘day’)

many thanks

1 Solution

Accepted Solutions

Bingo! it worked :slightly_smiling_face: thanks so much

See Solution in Thread

2 Replies 2

Hi Clare, could you try: DATEADD({Date Invoice Raised}, 30, 'days')?

Bingo! it worked :slightly_smiling_face: thanks so much