Hi there,

Please can you help! I am trying to calculate from a list of dates,
which calender Period the date falls into.

I have a table in excel with period number in first col1, period start
date in col2, period end date in col3.

I then have a list of about 500 dates and want to put in the column
next to each date which period the date equals.

I've tried nested if and offset functions but cannot figure it out!!
If anyone can help, we would be most greatful.

Meg