Oops... apologies. I was relying only on Match with True check, which used to check less than values.
Now, I have used simple Array with Max function to derive the required result(s). Let me know if this helps. Regards, DILIPandey On 10/13/11, BS <sharma.aipl....@gmail.com> wrote: > Hii Dilip... > Thank you very much for your work... > > This is very close to what I want... but not been perfect.. > > Check that when I put 09-Aug-2010 in the cell B3 its showing 01-Jul-10 > instead of 08-Aug-10 > > I want to automatically generate a date from a database, which Is equal or > preceding to the given criteria. > > Thanks & Regards, > B. Sharma > > > > > -----Original Message----- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: 13-Oct-2011 12:54 AM > To: excel-macros@googlegroups.com > Cc: sharma....@gmail.com > Subject: Re: $$Excel-Macros$$ Selecting a date from a database, which equal > to or lesser than the selected date > > Hi, > > Use the formula :- > =OFFSET($A$1,MATCH($B$1,$A$1:$A$6,1)-1,0) > > Sample worksheet is also attached for your ready reference. Let me know if > this suits your requirements. > > Regards, > DILIPandey > > On 10/12/11, B Sharma <sharma....@gmail.com> wrote: >> Dear Excel Experts.... >> I want to select a date which is either equals to or lesser than the >> select date. >> >> For Example >> >> in Column 1 I have different dates >> >> 01-Apr-2010 >> 01-Jul-2010 >> 15-Aug-2010 >> 01-Oct-2010 >> 15-Nov-2010 >> 08-Aug-2010 >> >> (sorted and un sorted both) >> >> In Cell B2 I have entered a date, say. 15-Sep-2010 In Cell C3 I want >> a formula which will return the date either equals to B2 or 1 time >> lesser than it. >> In this case the result will be 15-Aug-2010 >> >> >> Please help.... its very urgent >> >> -- >> ---------------------------------------------------------------------- >> ------------ >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Selecting equal or less date by DILIPandey-v1.0.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet