Dates must be chronological. Results are calculated when you tab/click out of a cell or click Calculate.