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]")