Capture.GIF
Hi,
I have a set of dates and I wish to bucket them according to my company's fiscal months. For example, 2/25/13 falls within fiscal March and my date range table (C1:E7) is aligned as such. What kind of formula can I use so that when I do a lookup on any date in column A, it will return the proper value from column E? Any help would be appreciated. Thanks!
Chirag
Bookmarks