Please Help. WeekNum to Pay Period column/Formula
l'm creating a workbook for tracking meetings. I've just generated a pivot table calendar from a sheet with the following columns: "Date, WeekNum, WeekDay, Day, Month." It's great! However, I desperately need either the week number to align with the pay period calendar (starting on XX/XX/YR instead of 01/01/YR), or I need a column that is going to show the pay period week formulated off of the week number- but starting over at the end of the pay period year (So it can't just be a basic cell/value+#). Also, I'm COMPLETELY new to this, so I'm way in over my head with the formulas- but work is work. So, basically explain step by step what to do, or else I'll be lost. Thanks!