Lookup Formula
In Excel2000, I have the following data:
Weekending Fiscal Month
2/19/2005 FEB
2/26/2005 FEB
3/5/2005 MAR
3/12/2005 MAR
I want to have a lookup formula that looks up all dates before the
weekending date. For example for the following:
2/25/2005 = Feb
2/26/2005 = Feb
2/27/2005 = Mar
2/28/2005 = Mar
2/29/2005 = Mar
3/1/2005= Mar
Thanks
|