View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default #NAME? error in aging calculations

I am getting a "#NAME?" error in cells J5 and K5, ...

Instead of
(NETWORKDAYS,A1,C5)
in the formulas, try
NETWORKDAYS(A1,C5)
and likewise for other instances.