Help on Numbering by week

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

Hello!

I have a [DateReceived] field in my report which sorts by
the week. I have a date range criteria set up for the
report so it reports 8 weeks at a time.

I need a formula for a field which will tell me "Week
1","Week 2" and so forth up to week 8. How do you folks
suggest this..?

Thank you.
Lou
 
You can use the Weeknum function to determine teh current
week and use a calulation from this to determine the date
and project the future or past 8 weeeks. You may need to
install msowcf.dll.

WEEKNUM(serial_num,return_type)

Return_type could be left blank which would start the new
week on Sunday and end it on Saturday.
Hope this helps.
FOns
 
Hello FOns!

Thank you for the information. I was not able to get it to
work the way I wanted to. I have a date control which
gives me the week of the year, I think I need a formula to
recognize the date and then assign a value to emty cell
which is 1 thru 8 "earliest to lastest". I hope this makes
sense..If I am not interpreting you response correctly
please let me know.

Thank you.
Lou
-----Original Message-----
You can use the Weeknum function to determine teh current
week and use a calulation from this to determine the date
and project the future or past 8 weeeks. You may need to
install msowcf.dll.

WEEKNUM(serial_num,return_type)

Return_type could be left blank which would start the new
week on Sunday and end it on Saturday.
Hope this helps.
FOns
-----Original Message-----
Hello!

I have a [DateReceived] field in my report which sorts by
the week. I have a date range criteria set up for the
report so it reports 8 weeks at a time.

I need a formula for a field which will tell me "Week
1","Week 2" and so forth up to week 8. How do you folks
suggest this..?

Thank you.
Lou
.
Click to expand...
.
Click to expand...
 
Back
Top