It may have something to do with your sheet names. Look at these:
http://www.business-spreadsheets.com/forum.asp?t=36
http://www.mrexcel.com/archive/Errors/21047.html

Or, there is no data on the sheet...........

Look closely. Whatever it is, you will most likely find it before anyone
else does (we can't see what you are seeing).

Good luck,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Orrin" wrote:

Thanks. I'm trying to do it in a pivot table, so I'm inserting a calculated
field but the today() function won't work. How can I create a calculated
field to do this so that it's part of my pivot table?


"ryguy7272" wrote:

Now will give you time and date, then you have to strip out the time, if you
just want the date. So, use =today()

That will give you 28 days from March 1st. Is there somethign else? Maybe
you need to name your range, such as naming the cell that contains 3/1/09,
especially if you will be refreshing your Pivot Table and the cells will
change daily.

Well, just some food for thought. Fiddle around with it for a bit and see
what happens.

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Orrin" wrote:

I have a date in my pivot table data and I'd like to calculate in a field an
'aging' number of days since today. So, for example, my item has a date of
3/1/09 and today is 3/29/09, I'd like to calculate to 28. This, of course
would change every day the pivot is refreshed.

I've tried using NOW type functions in my pivot table field calculation, but
no luck. Any suggestions?

Thanks,

O
Orrin Wolf