BUT doesnt work if the 1st date is in a different year, ie the arrived say in Nov & left in Feb???



oops

The formula above has a flaw. It doesn't work if someone arrived on a previous year and still has not left.

M.