Formula Field: Count Days between two dates IF...

Question

I need help with a Formula.

This logic does not work for me....

IF(ISBLANK(FieldA__c),FieldB__c - Today(),FieldA__c - FieldB)

What this says. If FieldA is blank. Subtract Field B from Today. If FieldA is Not Blank. Subtract FieldA from FeildB.

Please Assist.

Thank You

Charu Soni · Answer

Hii Daniel

Try Below Formula I've Made Some Changes In Your Formula It Was 'FieldB' changed To 'FieldB__c'

IF( ISBLANK( FieldA__c) , FieldB__c- TODAY() , FieldB__c- FieldA__c)

Please Mark It As Best Answer If It Helps

Thank You!

Formulas