Formula for no data with weeks

[nigo75]

Hi,
Is there a way I can include week numbers 1-52 across my data current my sheet only shows the weeks that have data 1,2,3,6,7,8,11,12 etc.
I wish to display all weeks automatically in my chart. Mainly to show/work an even spread across the 52 weeks and where the anomalies are. both in data and then on a pivot chart. Note I currently get the week number from a date in another cell which is maintained manually and changes frequently.

[newdoverman]

Insert the week numbers where necessary to complete the weekly series and leave the associated data cells empty.

[nigo75]

Insert the week numbers where necessary to complete the weekly series and leave the associated data cells empty.

Im current getting my week numbers from a specific date and time cell which dosent allow me (this is also over many years of data both past/present/future) 1000's of rows

[FDibbins]

have you looked at the weeknum() function?

[newdoverman]

You will likely need VBA to insert the missing week numbers into your data.

[nigo75]

You will likely need VBA to insert the missing week numbers into your data.

Thanks that was what I thought due to me gettting the data from the date cell and not vice versa.