Hi Brian, Sorry to re raise this... I was wondering what operating system are you using as I was wondering if an older version of excel could be the root cause of why the dates aren't working.Cheers BC

OK Thanks again Brian,. Its just bizarre as it always reverts back to finish on Saturday with the custom expression... the expression you provided includes the sunday as well so looks like will have to follow up with client care... 

Hi Brian, Thanks for replying. I tried that but I am again presented with the same problem. Perhaps if I give more detail.  I am trying to do a 12 week rolling monday - sunday reporting time period. When i used the expression you provided yes the first week started on Monday but it still finished on...

When I go to select rolling weekly dates it seems to revert to a Sunday to Saturday date range. Is there an easy way to make it Monday - Sunday? I have tried to customise expression and link up via cells but no matter what it seems to always revert back to sunday to saturday. Any ideas or am I missi...