Date calculations resulting in negative numbers and averages

[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

 

[Gary''s Student]

=IF(DAYS360(C3,D3)<0,"",DAYS360(C3,D3))

 

[Radrays]

Perfect...thank you for today's and yesterday's help!

 

[Gary''s Student]

You are quite welcome.
Thank you for the feedback.

 

[Dave Peterson]

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.)