Mr Abhishek Jain, There is problem with the function when the following dates are given.
29/01/2010 30/01/2010 31/01/2010 Please check and modify it. Regards, Kishan Reddy, K On Jul 30, 9:47 am, Abhishek Jain <abhishek....@gmail.com> wrote: > You're welcome. > > However, both works. 1st one is having reference of the text, and in second > one, text is within the formula. That's the only difference. > > AJ > > On Thu, Jul 29, 2010 at 1:42 AM, sudarshan rampe <sidhu...@gmail.com> wrote: > > thanks abishek the second one worked out.......... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
