Conditional Calculated Field

[raweber]

I am writing a project tracking db and have a field for days in queue. This is a simple calculated field subtracting the start date from the current date.

I would like to change the forumula to be End Date minus Start Date when there is an end date, and Current Date minus Start date when there isn't.

I know I can use conditional formatting to change the label, but is there a way to change the forumla in the field?

Thanks, Rob