I have three seperate cells "Year" "Month" "Day". I need to get the day of week out of it. Can I concantinate three values to get the day of week back.

As a quick example how can I make this work

A B C
2006 January 1

=weekday(A1&B1&c1)