The number of days / months remaining on an Assignment used in the Assignment Derived Calculations view is calculated using a DATEDIFF() function where the difference in days / months is returned between the Today's date and the current Extended End Date. If a null reference is returned for Extended End Date, the difference in days / months between Today's date and the Scheduled End Date is calculated instead.