I want start date to be as Week 1

[pamela16]

Hi Please can you help me, I have this formula

=TRUNC((K5-DATE(YEAR(K5),1,1)+WEEKDAY(DATE(YEAR(K5),1,1))-1)/7)+1

But at the moment it's show the week number of the year. I want to show the start date as week 1 and so on.

[AndyLitch]

Something like

=WEEKNUM(D12)-WEEKNUM(StartDate) +1

[pamela16]

Thanks AndyLitch. the start date changed to Week 1 but as you go along the dates it didn't change to week2, 3, 4 all the dates changed to week 1.

[AndyLitch]

You need to change the reference between the two dates.... If you could upload your file it would be easier to fix.

[pamela16]

Here's the file

[daddylonglegs]

WEEKNUM won't work for you if your dates span across more than 1 calendar year. If you have start date in B4 (change as required) then this formula will give you the week number for a date in K5 assuming that B4 is day 1 of week 1

=INT((K5-$B$4)/7)+1

If you want a "W" to display change to

="W"&INT((K5-$B$4)/7)+1

[pamela16]

that's is really great thanks