Calculated Column in Sharepoint with IF statements

Question

I would like to use two formulas to define the field 'Age'.

1. If the column 'Date Project is Completed/Cancelled' is populated, then Age = 'Date Project is Completed/Cancelled' - 'Date Assigned'

2. 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])

Answer 1

See all answers at: How to use Today and Me in Calculated column

You can not do Current Date calculations in a Calculated Column

---

The comparison part of your IF is with the OR function:

=IF( OR( [Date Project]="Completed" , [Date Project]="Cancelled"), TRUE, FALSE)