Hi Biff,

The dates in C13:Z13 are 31/07/06 01/08/06 03/08/06 ect

They are never in order because they may work 4days on and then 4off.

The dates in AY1 is 31/07/08
AY2 is 03/08/06

The start and end dates change whenever the user enters the start and end dates.

I need the forumla to look ON these days AND between them. So far the formula only looks for the EXACT dates and returns N/A if i was to enter say start date of 01/08/06 and an end date of the 04/08/06

Hope that clears it up....lol

Rhani