Not sure what your text mode formula is or your data in the columns you are calculating, but I would check there is a difference in the days you are pulling into your calculation?
Is Go Live Date Task Level different than Actual Completion Date?
DATEDIFF
Returns the number of days between the two ...