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]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]

28-12-2017​

[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]

05-01-2018​

[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]

10-01-2018​

[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]

14-01-2018​

[/TD]
[TD="align: center"]3[/TD]
[/TR]
</tbody>[/TABLE]



In A1:

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