Week number in the pivot table

**jimpatel1993** · 09-30-2021, 06:54 AM

Hi,

Thanks for looking at my post.
I got stuck with pivot table and any help will be appreciated.
I have pivot table with date on the column. I am looking for some formatting like

2019 2020 2021
Week 1 till week 52 week1 to week 52 week1 to week 52

instead of attached format. Any idea guys?

Thanks a lot

**romperstomper** · 09-30-2021, 07:28 AM

Have you tried just adding a column using the weeknum function?

**jimpatel1993** · 09-30-2021, 08:14 AM

Just found the date format is not right. I tried to change formatting to date but it does not work for some reason. Any idea pls?

I have attached in this message.

Thanks a lot

**romperstomper** · 09-30-2021, 08:55 AM

Use the Data - Text to Columns feature. Use the Delimited option, leave all settings blank and in the last step choose Date as the type and DMY as the format.