Is It Possible To Find/Replace Dates In Pivot Tables and Cell Formulas?

[ScotyB]

Greetings all,

I have several worksheets with pivot tables to do various calculations for me and each of these pivot tables has a date filter to look between two specific dates (ie: 22 Jan 2012 and 21 Feb 2012) - is it possible to code a find/replace for the year component? There are so many pivots that I don't want to manually change the date filters each year so, can I replace the 2012 with say, 2014, or whatever year I need?

And the question is the same for a range of cells containing COUNTIFS formulas where two of the conditions are related to dates? Can I do a find/replace within the cell formula?

Cheers,

AJ

[ScotyB]

I just realised that I probably should have included at the least, an example of the cell formula, so here 'tis...

=COUNTIFS(EvalDates,">=22/1/12",EvalDates,"<=21/2/12",Evaluations!$E:$E,$A$19)

The cell range containing the formulas is C22:AP44 and each cell contains a nearly identical formula; the only thing that changes is the Evaluations! part...

Will that help or would it be easier to upload a sample of my messy work? (I will need to strip out some data to make it generic)

Cheers,

AJ