Help

DATEADD returning the added field date instead of the result

Topic Labels: Formulas
1169 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Osnat_Melnikov
4 - Data Explorer
4 - Data Explorer

Hi,
Struggling with DATEADD formula, trying to get an hours bank result from:
Date of purchase and days left to use.
for some reason, I keep getting the first date I entered- The date of purchase.
Appreciate the advice.

3 Replies 3

Hi @Osnat_Melnikov

Welcome to Airtable Community!

Please paste the formula you are using here with a screenshot of both fields so we can help you.

To be clear, if you are trying to get the difference between 2 fields you can use the DATETIME_DIFF

Hi, thanks for your welcome!
I’m looking to add the date of purchase and days of use to set the ending date of the package
מועד סיום חבילה

Welcome to the Airtable community!

Your field for {days of use} is a lookup field. (Sorry, but I cannot read your field name in its original language.) Convert that field to a rollup field instead. Use a rollup formula like SUM(values).