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)
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks