Hi,
Thanks for your reply.
I think I couldn't explain my question correctly.
I have dates in cell A5 to A300. These cells are having dates.
I want to figure out 1st date of the quarter. For e.g, there are dates from 8-Nov-2007 to 28-oct-2012. I want 1-oct-2007 as result.
Your formula...
Hi,
I have list of data having dates. This data is having dates for 5-7 years.
I want to figure out 1st data of the quarter. For e.g, there are dates from 8-Nov-2007 to 28-oct-2012. I want 1-oct-2007 as result.
Data is dynamic and it changes.
Amit