Hi Guys,

I'm Stuck ....

I have a date range with start date and end date
INFO!D5 = start date
INFO!D6 = end date

I need to find out in this range ( start and end) how many days fall :

1. Days Before 01/03/11
2. Days Between 01/03/11 + 01/06/11
3. Days after 01/06/11

i have the before and after dates working but its where have dates running between i get stuck

if i have a date that run like
26/02/2011
27/03/2011

I need to show - 2 before 01/03/11 and 27 after 01/03/11

or if a date runs like
26/05/2011
27/06/2011

I need to show - 5 between 01/03/11 + 01/06/11 and 27 after 01/06/11

Any ideas ?

Thanks,
Saz