How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

Not only do I need to see from "Date Created" to "Date Completed", but would also like to see "Date Created" to Todays Date if not completed.

Try this as a formula numeric field called [Project Duration Days]

var date EndDate = IF(not IsNull([Date Completed]),[Date Completed],Today());

ToDays($EndDate - ToDate([Date Created]))

The built in field for [Date Created] is actually a date/time field type so that is why it needs to be converted to a date with the ToDate function.

Worked Perfectly!!!   Thank you so much!!