Lets try this again...
I am using this current formula to calculate the week number, though what I need to include is the year as well. I am using a getpivot on another sheet to compare to =now.
=INT((C138-SUM(MOD(DATE(YEAR(C138-MOD(C138-2,7)+3),1,2),
{1E+99,7})*{1,-1})+5)/7)
What I am looking for:
01/2008
Week/Year
Any help in the right direction would be great!
Bookmarks