hi folks hoping someone can help, i have a basic sheet for work which shows a date when some made a claim in the next column headed weeks i want it to work out how many weeks has passed since the have claimed i have already inserted a dynamic cell for a updating date field for each time spread sheet is open. also after 13 weeks i want it to highlight automatically

thank in advance