The decision as to whether New Year's Eve is normally left to the ship, but I believe most try and make it a formal night.
In my never so humble opinion New Years Eve is one of the best nights to be at sea. The ships are alive! Everyone is out of their cabins and participating in the festivities somewhere. You can travel throughout the ship enjoying the parties everywhere!