Week Num and using Dynamic Dates

[PCRIDE]

I have a Week Ending Date Ranges that follow every Sunday.

My report has a box the user enters the Week Ending they want to see, then the report will populate the next 7 week endings to view report.

So if the user enters week ending 3/17/12, the report will populate the next 7 weeks, I simply do a formula =+7, this will add 7 days to the 3/17/12 making the next row 3/24/12. All this works great. However other dependencies on my report rely on a WEEK number, so I point WeekNum to the field where i have =+7, however the weekNumber doesn't work and gives wrong Week Numbers.

I think this is because WeekNUM is pointed to a Date that has the =+7. When I just typed in the same date, the correct WeekNumber populated.

What is a work around? I need the next 7 dates to populate so the report is dynamic.

 

[PCRIDE]

So I just re-did the formula and it works now. Maybe this is a bug or corruption

 

[CharlesChuckieCharles]

WeekNum needs a serial date but doesnt appear to evaluate if the date could be serial just wants a serial date

so WeekNUM((12/03/2012)+7) ignores the date gives you 1 ( 7 days)
WeekNum(A1) okay if A1=12/03/2012
WeekNum(A1) Bad if A1=12/03/2012+7
WeekNum(A1) Good if A1=B1+7 and B1 = 12/03/2012
WeekNum(A1) Good if A1
=DATE(YEAR(B1),MONTH(B1),DAY(B1)+7)
And
=WEEKNUM(DATE(YEAR(B1),MONTH(B1),DAY(B1)+7)) Good

 

[PCRIDE]

So I had mine configured as your 4th bullet. Once I recreated it, the weekNumber changed to the correct week.

I am not sure what was going on here, the formulas were the same.

Thanks for that info, good to know!!