weeknum

avinashraste

Board Regular
Joined
Mar 12, 2008
Messages
167
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

avinashraste

Board Regular
Joined
Mar 12, 2008
Messages
167
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

Board Regular
Joined
Mar 12, 2008
Messages
167
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

Well-known Member
Joined
May 8, 2015
Messages
508
AB
1
28-12-2017​
1
2
05-01-2018​
2
3
10-01-2018​
2
4
14-01-2018​
3

<tbody>
</tbody>



In A1:
Code:
=int(max(1,a1-$a$1)/7)+1
 

Watch MrExcel Video

Forum statistics

Threads
1,099,372
Messages
5,468,227
Members
406,574
Latest member
HeinrichPaul

This Week's Hot Topics

Top