=IF(P5="","",IF(AND(R5="",S5=""),DAYS360(P5,TODAY( )),IF(AND(R5<"",S5<""),"Error",DAYS360(P5,IF(R5= "",S5,R5)))))

I think this is what you want. Hope it helps :)
--
** John C **


"HeatherBelle" wrote:

Here is a sample from my workbook: (Yes, my columns have changed, I've added
another column since I posted earlier)

P Q R S
Date to AOV Days Out Effective Date Denial Date
02/15/08 ???? 03/05/08
1/31/07 ???? 3/01/07

I don't want anything to show in Q if P is blank (otherwise, I get a really
large number sitting there because there's no data for it to compute)
I want the count to keep rolling until a date is put into either R OR S
(there will never be one in both)