Calculated Column Based on Start and End Dates

Question

I'm trying to create a calculated column for a list that tracks personnel travelling.

There are two date columns in the list, one for their departure date and one for their return date.

I want a calculated column to identify their current status. Basically if neither date has passed I'd like it to say "Pending", if the departure date has passed but not the return date then "Abroad", if both dates have passed then "Complete".

I tried the below formula but keeping getting a syntax error. Can anyone see what's wrong?

=IF(AND([Departure Date] > NOW(), [Return Date] > NOW()), "Pending",
    IF(AND([Departure Date] <= NOW(), [Return Date] >= NOW()), "Abroad",
        IF(AND([Departure Date] < NOW(), [Return Date] < NOW()), "Complete", "")
    )
)

Answer 1

The formula works for me (using semicolon ";" instead of comma ",").

=IF(AND([Departure Date] > NOW(); [Return Date] > NOW()); "Pending";
    IF(AND([Departure Date] <= NOW(); [Return Date] >= NOW()); "Abroad";
        IF(AND([Departure Date] < NOW(); [Return Date] < NOW()); "Complete"; "")
    )
)

Answer 2

I tested your formula and it works fine for me here. I have my date and result columns set up as follows.

If the problem persists, then you can try:

1.Whether all SharePoint lists have the same problem? You could create a new SharePoint list to check.

2.You could try to clear browser cache then restart it.

3.Try to use a different browser or your browser's InPrivate mode to see if the same error occurs.