Formula to calculate Period & Week into Date?

ok so at my work there are 13 periods in a fiscal year, 4 weeks per period.

just started the 2009 fiscal year on sept 1st

period 1 week 1 is Sept. 1 - 7
period 1 week 2 is Sept. 8 - 14
period 1 week 3 is Sept. 15 - 21
period 1 week 4 is Sept. 22 - 28

period 2 week 1 is Sept. 29 - Oct. 5
etc.

on my input sheet i want to put the Period number and Week number into two cells and have it calculate into the "date" cells on my other sheets

for example

i have an input sheet, and one sheet for every day of the week.

if i put "1" in the period cell and "3" in the week cell.. i want the monday sheet's "date" to show up as "9/15/08" and the tuesday sheet to show "9/16/08" and so on

any ideas? would i have to have a cell for the fiscal year as well?

thanks

Originally Posted by protonLeah

Here's one solution, it will be off next year, though:

Attachment 27947

sweet thanks, oh i also forgot that theres an extra week in one of the periods, i forget which one.