I need a formula to calculate based on 2 scenarios for aging job vacancies.
the data reads as follows:

A B C D E
STORE POSITION DATE OPEN DATE FILLED TODAY
4 ASM 3/1/2005 6/23/2005 7/1/2005
3 SALES 4/10/2005

I want the formula to look at column D for a date, or a blank. If Blank
calculate days between date open & today. If D is not blanK, calculate days
between C & D. Is there an IF statement I can use for this?

Thanks for any help!

Cyndi