I had a calculated field in a table that I was using to populate a PivotTable. All the other fields appeared in the field list, but no matter what I did, the calculated field wouldn’t show up. Refreshing, closing and opening the file didn’t work, exiting and re-launching Excel didn’t work. What finally worked: closing Excel and leaving the computer alone for a day. The following day, the field appeared in the list and I was able to use it in the PivotTable. Weird.
Between the Sheets — Excel podcast episode 31: Excel’s secret DATEDIF function
A quick and simple way of finding the number of days, months or years between two dates is Excel’s secret DATEDIF function. When you type it in a worksheet, there’s no popup syntax help to indicate the function exists.