weeknum

[avinashraste]

Dear friends,

I want to use weeknum function for the entries from 1st of September. But I want the entries, starting from 1st of September as Week 1.

Where as the function returns the week number 35. So my query is, can we have customized weeknum ? I mean, can I start 1st Of September as Week 1 and then Week 2 from September 8 and so on ?

Regards,
AR

 

[Scott Huish]

With date in A1, does this work for you?

=WEEKNUM(EDATE(A1,-8))

 

[avinashraste]

With date in A1, does this work for you?

=WEEKNUM(EDATE(A1,-8))

Dear Scott Huish,

First of all thank you very much for the kind reply.
The solution you've suggested worked like a charm. Thank you very much once again for this reply with fantastic solution.

Regards,
AR

 

[avinashraste]

Dear friends,

I want to use weeknum function for the entries from 1st of September. But I want the entries, starting from 1st of September as Week 1.

Where as the function returns the week number 35. So my query is, can we have customized weeknum ? I mean, can I start 1st Of September as Week 1 and then Week 2 from September 8 and so on ?

Regards,
AR

Dear Scott,

Your suggestion worked very well ( You have suggested "=WEEKNUM(EDATE(A1,-8)" ) with the date 01/09/2017 as week 1.

What can I do if I want to keep 28/12/2017 as week 1 ?

Please guide,

Thanks & Regards

A Raste

 

[Nishant94]

	A	B
1	28-12-2017​	1
2	05-01-2018​	2
3	10-01-2018​	2
4	14-01-2018​	3

<tbody>
</tbody>

In A1:

=int(max(1,a1-$a$1)/7)+1