I would like to use two formulas to define the field 'Age'.
If the column 'Date Project is Completed/Cancelled' is populated, then Age = 'Date Project is Completed/Cancelled' - 'Date Assigned'
If the column 'Date Project is Completed/Cancelled' is not populated,
then Age = 'Current Date' - 'Date Assigned'
This is the formula I used but SharePoint will not accept:
=IF(ISBLANK ([Date Project is Completed/Cancelled]), [Current Date] - [Date Assigned], [Date Project is Completed/Cancelled] - [Date Assigned])