Thanks for both of your replies... Sorry late replying but only just in.
njimack
This formulae does work, is there anyway to do this from the 1st weekending sunday in April? Also is there any way instead of referring to A1,A2,A3 etc to do this by the tab number 1,2,3,4,5, etc???
Oaktree
This is a very good comment, but I was going to do this once I had the formulae.
I am trying to get the formulae to work from the financial year Arp - Apr
For week ending Sunday, I know that there will be some disprepancies, but I think just a rounded figure will be good enough...
Any other suggestions??