Formula Query

[broncos347]

I am trying to work out how to do the following:

I have column F which lists the total number of surveys currently undertaken in 2011 and I am trying to work out how many of these have been carried out in the last four week period - I have another table which holds the start (column Z) and end (column AB) dates for the 4 week periods.

Can anyone help?

 

[SteveO59L]

Where do you hold the date the survey is undertaken?

 

[broncos347]

The date is shown in column D on a seperate sheet called "survey data" within the workbook.