Yes, that's fine. "How was your weekend?" is perfectly correct and very natural. Let me just correct the rest of your post, though. This is how it should be: Is it correct to say "How was your weekend?" I want to know how your weekend was. or I want to know what your weekend was like.