how can we aggregate date to find the week number?

[#1]

Hello Everyone,

I am making a forecast table in which ForecastDate is there and i need to aggregate the dates to find the Forecast Table week wise.

What sinario i should use?

how can we aggregate date to find the week number?

Thanks in advance.

[#2]

using the week() function