Defining fiscal month for pivot table
 

I am generating expense reports by month using pivot tables. Unfortunately,
we use a 4, 4, 5 week calendar that has the month always end on a Saturday.
Is there an easy way to do this? ie "February" starts on 2/3/07 and ends
3/3/07.

Thanks

Defining fiscal month for pivot table
 

Assuming start date in A1:

In B1: =7-WEEKDAY(EOMONTH(A1,0),1)+EOMONTH(A1,0)

Makesure you have Analysis TookPak Add-Ins



"Paul" wrote:

I am generating expense reports by month using pivot tables. Unfortunately,
we use a 4, 4, 5 week calendar that has the month always end on a Saturday.
Is there an easy way to do this? ie "February" starts on 2/3/07 and ends
3/3/07.

Thanks