XIRR returning #VALUE!

Question

I'm relatively new to excel, and I'm using the XIRR function. I've inputted dates in chronological order and I've formatted the dates so that the cell is in "Date" as a number. I've inputted values beneath them as my cashflows, starting with a negative number. When I calculate the XIRR it is just returning a #VALUE! What am I doing wrong??!!

EDIT: I was inputting the dates as 1.1.24, for example. When I changed it to 1/1/24 it worked! Even though the Excel selection in the formatting Date list shows a format of 1.1.24.....it should work! But using the "/" as a date separator seems to have solved the problem.

Answer 1

XIRR(values, dates, [guess])

XIRR function - Microsoft Support

The second parameter must be a date format.

To confirm if a date is date format instead of text. Change it to Number format. If it shows a number like 45XXX, it is date format. Otherwise, you need to change it to a date value.

.

We are glad to hear you had resolved it. Feel free to come back if you meet any issue about Excel and thank you for sharing the solution.