Okay. Perhaps I should tackle this differently, I am getting the circular reference error. I know it's because I'm using fields with formulas in them as part of my formula. I need to know how to get around this.

Since field Q29 has a formula in it to sum fields D29-P29, then I'm using the sum of field Q29 to calculate the results of my formula in field C20, perhaps I could tackle this differently. How can I create a workday formula that only calculates the date if the sum of fields D29:P29 doesn't equal zero. If the sum of fields D29-P29 is anything other than zero, then I want to calculate the date. Here's what I have, but it's not working...

=IF(SUM(D29:P29)=0,"",WORKDAY(TODAY(),0,$S$2:$S$13))

Where D29 through P29 have formulas in them to calculate their totals.

The formula I have in D29 is... =IF($C29="","",COUNTIFS('ALM Export'!$H:$H,">"&$C30,Summary!I:I,D$2))

So my real question is this... I have come up with this formula =IF(SUM(D29:P29)=0,"",WORKDAY(TODAY(),0,$S$2:$S$13)), but I don't think it's working because D:29-P29 are fields that their totals are calculated by a formula as well. So how can I fix this formula so that it allows me to calculate the sum of fields D:29-P:29, even though D:29-P29 are using formula to display a total. Then if the sum of D:29-P29 is 0, display blank, if the sum of D:29-P29 totals more than zero, then do the workday formula?