Thread: why can't I change the date with find and replace in this formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MLTDebbie MLTDebbie is offline
external usenet poster
  
Posts: 1
Default why can't I change the date with find and replace in this formula
=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
Reply With QuoteReply With Quote