Conditional formula start date, end date unless blank, then current date

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need a Conditional formula. I have a start date. If I have an end date I need it to count the days. If I do not, it is blank and I need it to count the days from start date to current date.

I have the formula for the first part:   

[Disposal Date]-[Accumulation Start Date]

but i do not know how to make it conditional if the field is blank.

This is what I thought might work but I keep getting errors.  

 If  ([Disposal Date] "<>" , "(Today)-[Accumulation Start Date]" , "[Disposal Date]-[Accumulation Start Date]")

Photo of Meme

Meme

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of Meme

Meme

  • 10 Points
 Got the answer. In case someone else needs:

[Disposal Date] <> "", [Disposal Date] - [Accumulation Start Date], Today() - [Accumulation Start Date]