Help

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

Formulas using dates

145 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone! I need to modify a formula that I have because I want to calculate a result in column A when B is greater than C AND also if B is blank. This is the formula I’m currently using and it needs modification: IF({DeStaging Date}<{Monthly Rental Fee Renewal Date},BLANK(),DATEADD({Staging Date},46,‘days’))

today

2 Replies 2
IF(
  OR(
    NOT({DeStaging Date}),
    {DeStaging Date} > {Monthly Rental Fee Renewal Date}
  ),
  DATEADD({Staging Date},46,'days')
)

Thank you so much!!! I greatly appreciate it!!