why can't I change the date with find and replace in this formula

M

MLTDebbie

=GETPIVOTDATA("Sum of Reg $",'01-10-08
Summary'!$A$4,"Dept.",101,"Hourly/Salary","Salary")

on the other worksheets I have for our various divisions I'm able to find
01-10-08 and replace with, for example, 01-25-08. When I try to do the same
here it wants me to open a file and then won't open it either
 

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

Find LAST date when corresponing min value became available 7
Converting 1-60 minutes to quarter minutes in a formula 5
Emulating older pivot table "engine" in Excel 2007? Need help... 0
Why formula should I use? 2
Sum of different accounts 1
Sumif date range 6
Finding the average using conditions in a logic function - problem 1
Comparing Dates in 4 Columns - Nested Formulas? 1

Top