Getting Week Number from a list of dates

[DaveSwanton77]

I have a table as shown below

Week| Start | End
1 | 1/4/2004 | 7/4/2004
2 | 8/4/2004 |14/4/2004
3 |15/4/2004 |21/4/2004
4 |22/4/2004 |28/4/2004
etc

I need a Query/formula that would return the week number for any given date i.e 11/4/2004 would be week 2 as it is between the start and end dates.

Thanks in Advance

Regards
Dave

 

[Launcher]

You can use the DatePart function in the expression builder. This allows you to use standard start dates i.e. 1 jan or to set your own. I hope this is what you are looking for. If you need any further help on this function it gives detailed instructions in the help menu.

Regards Launcher