Page 1 of 1
Week
Posted: Mon Nov 22, 2021 7:09 pm
by sna
Hi Dear,
I need your help how to get the results as in column B.i used the weeknum function but it is no luck.
I also attached a sample
Thank
Re: Week
Posted: Mon Nov 22, 2021 7:49 pm
by norkaz
...
B2
=INT(ROWS(B$2:B7)/6)
Norkaz
Re: Week
Posted: Tue Nov 23, 2021 9:39 am
by sna
thank you but another choice could it work with weeknum function?
Re: Week
Posted: Tue Nov 23, 2021 10:33 am
by norkaz
..
Hi Guy
As far as we know the weeknum function returns the number of each week.
Refer to your data that shows 6 days per week and skips the Sundays. If your data pattern is always like that, the formula at B2 should be...
B2
=WEEKNUM(A2)-WEEKNUM($A$2)+1
Norkaz
Re: Week
Posted: Tue Nov 23, 2021 11:45 am
by sna
Thank you
