Yes, I did forget an extra closing bracket... so Excel's fix is right....

but it should work after that with any date format... as long as the dates are entered in as dates and not text strings... and as long as you don't have any errors in that range....

what error is it giving you?