Deduce Week Number (of 52) from Date Field

[Master_Lionsale]

Hello,
we are trying to compile the numbers of calls received per week on a spreadsheet.

We would like a break down by day, week and Month.

Should we use pivot table or scripting?
What should be the configuration?

Thank you