Automatically find correct invoicing month

Hi

Need some help, and rather than create a really long date table, i wondered if there is a way (and i'm sure you'll know) how to reference in the correct accounting month for a specific invoice date,

The attached worksheet has a column with a selected range of invoice dates, and then an date range table which has the accounting months,
a quick solution to this would be very useful,

thanks in advance
Adi

In cell B3 you need:
=VLOOKUP(A3,F$3:H$14,3)
then copy down the column.

Note - this is based on the assumption that your table with month names encompasses all the possible dates available. In other words, it won't cope with invoice dates which are before the first month or after the last one.

works a treat, thanks