Need excel expert

[kashif.special2005]

Hi,
My name is Kashif Khan,
I wanted to extract quarter start and end date from today’s date
Let me explain
Quarter Start Date Quarter End Date
10/01/2010 12/31/2010
01/01/2011 03/31/2011
04/01/2011 06/30/2011
07/01/2011 09/30/2011
Just imaging that today is <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:date Month="2" Day="2" Year="2011">02/02/2011</st1:date> then the start date should be <st1:date Month="1" Day="1" Year="2011">01/01/2011</st1:date> and end date should be <st1:date Month="3" Day="31" Year="2011">03/31/2011</st1:date> like wise.
Please help.
Thanks & Regards,
Kashif Khan.

 

[scottylad2]

Use index & Match, the 1st one with 1 as the final argument to find the Starting Date and the 2nd one with 0, to return the End date based on the start date

Excel Workbook
	B	C	D
7	Quarter start Date	Quarter End Date
8	01/10/2010	31/12/2010
9	01/01/2011	31/03/2011
10	01/04/2011	30/06/2011
11	01/07/2011	30/09/2011
12
13
14	Lookup Date	Quarter S Date	End Date
15	01/06/2011	01/04/2011	30/06/2011
Sheet1

Excel Workbook
	D
15	30/06/2011
Sheet1

 

[kashif.special2005]

Hi scottylad2,

Thankyou very much for great trick.

Kashif.