Date calculations resulting in negative numbers and averages

  • Thread starter Thread starter Radrays
  • Start date Start date
R

Radrays

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
 
If you're just subtracting dates, then you should use:

=d3-c3
(and format the cell as General (not date).)

Or
=if(d3<c3,"",d3-c3)
(still formatted as general.)
 
Back
Top