Calculate Date: Ultimate Expiration Date minus Owner Expiration Notice

If Arrangement Type_c equals ‘Contract’
Calculate a Re-Bid Date_c which is the Ultimate Expiration Date_c minus Owner Expiration Notice.

Here’s the formula that worked:

IF( ISPICKVAL(Arrangement_Type__c, ‘Contract’) , Ultimate_Expiration_Date__c – CASE(OwnerExpirationNotice,”15 Days”, 15,
“30 Days”, 30,
“45 Days”, 45,
“60 Days”, 60,
“90 Days”, 90,
“120 Days”, 120,Null) , Null)

If you’d like to see how I ended up here and the conversation posted on Answers, visit

Much thanks to Jeff May, Damien Owen, and Andrew Johnson for taking the time and providing the guidance/solution.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s