When I enter a date into a cell I want a formula that would look thru the 26 different date ranges and select the end date of the previous date range and display that date. Also I’m not sure if I should have the date ranges in a separate worksheet or not.
Example: I enter the date 1/21/09 in cell M4, It would then look thru the date ranges listed below and display the end date of 1/9/09 in cell M8
Begin date End date
12/13/2008 12/26/2008
12/27/2008 1/9/2009
1/10/2009 1/23/2009
1/24/2009 2/6/2009
2/7/2009 2/20/2009
2/21/2009 3/6/2009
3/7/2009 3/20/2009
3/21/2009 4/3/2009
4/4/2009 4/17/2009
4/18/2009 5/1/2009
5/2/2009 5/15/2009
5/16/2009 5/29/2009
5/30/2009 6/12/2009
6/13/2009 6/26/2009
6/27/2009 7/10/2009
7/11/2009 7/24/2009
7/25/2009 8/7/2009
8/8/2009 8/21/2009
8/22/2009 9/4/2009
9/5/2009 9/18/2009
9/19/2009 10/2/2009
10/3/2009 10/16/2009
10/17/2009 10/30/2009
10/31/2009 11/13/2009
11/14/2009 11/27/2009
11/28/2009 12/11/2009
12/12/2009 12/25/2009
Bookmarks