I have a work book inside this workbook there are 7 work sheets (one for
each day). Each sheet uses columns A, B, C, D

I have sheet call weekly all in formation in this sheet from the 7th
everything work fine only one column it has text and there are several
duplicate. Example : clinic A, clinic B, clinic A
How to remove the duplicate from this column to be like this : clinic
A, clinic b and so on

other Questions
I am using this function to get week number =WEEKNUM(C12,1)  
is there any way to get it work

Is that possible and if so can someone please help with the formula for
making this work.

Any help would be appreciated.