Modified Date Formula for Pivot Tables

T

Tan83

I'm trying to build a Pivot Table based on results scattered across a variety
of dates. I would like to find a formula that would modify the dates to the
first of whatever month it took place in so the Pivot Table will chart all
jobs in one month as one, rather than separate per indivdiual dates.

Does anyone know of any formula I can use to create a modifed date?

Ex. January 26, 2009 to 1/1/09

Tanelle
 
S

Shane Devenshire

Hi,

=EOMONTH(A1,-1)+1

this assumes that the date is in A1

The EOMONTH function is part of the ATP in 2003, so you need to choose
Tools, Add-ins, and put a check beside Analysis ToolPak.
 

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

Pivot table show only current month? 1
Pivot Table and Grouping Problem 3
Is there a formula that will return only the month from a date? 5
How do I convert dates to months in Pivot Tables? 1
Pivot Table Problem 1
Date Formula 1
Pivot Tables 4
Countif or sumif for cumulative sums,pivot table & chart 2

Top