Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day of week concacted from three cells
=CHOOSE(WEEKDAY(CONCATENATE(day,"/",month,"/",year)),"Sunday","Monday","Tuesday","Wednesday"," Thursday","Friday","Saturday") try this where day is put a cell value where month is put a cell value where year is put a cell value try this -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=560647 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Day of week concacted from three cells
Hi MABeatty,
one way is create in a auxiar area a table as: Col M Col N January 1 February 2 March 3 .... December 12 and use a function like this: =weekday(date(a2,vlookup(b2,m1:m12,2),c2)) Format as custom ddd - to Sun or dddd to return Sunday hth regards from Brazil Marcelo "MABeatty" escreveu: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrong Week number | Excel Worksheet Functions | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |