Thanks for previous help.
Everything works in principle but have another glitch. The formula adds up the dates ok but I somehow need to take account of ...
Example...
1/10/13 to 14/10/13 is 14 days but the formula adds it as 13 because I am doing a subtraction, I managed to get around that by adding 1 on to each date calculation, however I need to get the cell M11 to show the same total as E18.
Can the formula in M11 be adjusted to compensate?
I have attached the file.
thanks
Bookmarks