When I use XIRR, how do I make the Date format work? I tried changing the
cell format to Date, used the DATE format option, but still Excel sees the
date as a number not date format.