Thread: Day of week concacted from three cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MABeatty MABeatty is offline
external usenet poster
  
Posts: 1
Default Day of week concacted from three cells

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)


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=560647

Reply With QuoteReply With Quote