Thread: Date calculations resulting in negative numbers and averages
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Radrays Radrays is offline
external usenet poster
  
Posts: 14
Default Date calculations resulting in negative numbers and averages
Thank you for your time - I have a two fold question please.

I am currently using =DAYS360(C3,D3) to calculate aging betwen dates. Is
there a way to leave blank any cell with a value less than zero?

Is there a formula I can use to take my calculated values from above and
find the average aging?

Thanks again,
Radrays
Using XP - Office 2007
Reply With QuoteReply With Quote