*Hi santosh, *thanks for quick reply.* * *1/20/2010 * *17-Jan to 23-Jan* * * *40198 whose week is 17-Jan to 23-Jan* * on 40198 i want to show my DATE that is 1/20/2010 whose week is 17-Jan to 23-Jan i want to concatenate the value which i calculate in B2 coloumn*
On Wed, Jan 20, 2010 at 12:57 PM, Santhosh Kumar M K <mks....@gmail.com>wrote: > Hi Ganesh, > > Please find attached file. I made some changes.Please refer. I think it > will help to you. Thanks > > Regards, > Santhosh,Bangalore > > On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw <ganesh200...@gmail.com>wrote: > >> hi guys, >> i want to concatenate date with week but am not able to do that. so pl >> assist me. he showing some value after concatenation. >> am attaching a file. Pl assist me. >> >> -- >> Ganesh Gawde >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > -- Ganesh Gawde
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
