Hi,

I have a little table which looks up a period number, and also has 4
columns for the week numbers of the period.

Example

Period week 1 week 2 week 3 week4
P1 05/04/10 12/04/10 19/04/10 26/04/10
P2 03/05/10 10/05/10 17/05/10 24/05/10

I have worked out a simple formala, to say if todays date is 13/04/10,
it will return period P1. (as its between 05/04/10 - 03/05/10)

What i am trying to do, is to now work out the week number , which
should be week 2 (as its between 12/04/10 - 19/04/10)

Any help fully appriciated.

Thanks