Fiscal week and fiscal week start date and end date

**Nunzio** · 05-07-2012, 08:32 AM

I am trying to calculate my fiscal week number from a date, my fiscal year starts on 07/02/2011 and goes from Saturday to Friday. I am also trying to calculate the fiscal week start date and end date from the fiscal week number? Attached is the formula I was using for the week number.

Thanks Nunzio

**dilipandey** · 05-07-2012, 08:56 AM

Hi Nunzio,

You missed to attach the formula which you were using for the week number...

Regards,
DILIPandey

<click on below 'star' if this helps>

**Nunzio** · 05-07-2012, 09:46 AM

G2 is my date and this formula seems to be giving me the correct FW, how would I get the correct start and finish dates for the week from the results of this cell?

INT((G2-WEEKDAY(G2+1)-DATE(YEAR(G2+7-WEEKDAY(G2+1)),1,1))/7)+28

**dilipandey** · 05-07-2012, 01:25 PM

Hi Nunzio,

I am still not clear..
Would suggest you to upload an excel file with the above formula with little explanation. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>