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
Bookmarks