Defining fiscal month for pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Assuming start date in A1:

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

Makesure you have Analysis TookPak Add-Ins
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the Number of Weekdays by Month 3
Pivot Table Duplicate January 2
Fiscal Month Formula 3
Pivot Table Fiscal Years 1
Grouping by month in a Pivot Table 1
Countifs or a pivot 1
Pivot Table Calculations 1
Pivot Table Set Up 2

Back
Top