While trying to create a formula that says if a certain field is blank, return blank, otherwise return the date for the workday formula. Here's the formula I'm using... I'll list two as I am pulling the workday less 1 business day, then less two business days, then less 3 business days, etc... all the way out to less 60 business days.
Formula to show today's date if field Q29 doesn't equal 0: =IF(Q29=0,"",WORKDAY(TODAY(),0,$S$2:$S$13)) The field I'm using this formula in is C31.
Formula to show last business day's date if field Q30 doesn't equal 0: =IF(Q30=0,"",WORKDAY(TODAY(),-1,$S$2:$S$13)) The field I'm using this formula in is C32.
I keep getting circular reference error when I try to execute this formula with the If statement included. Attaching my circular reference error, I am unable to figure out what the circular reference is.
Formula to show today's date if field Q29 doesn't equal 0: =IF(Q29=0,"",WORKDAY(TODAY(),0,$S$2:$S$13)) The field I'm using this formula in is C31.
Formula to show last business day's date if field Q30 doesn't equal 0: =IF(Q30=0,"",WORKDAY(TODAY(),-1,$S$2:$S$13)) The field I'm using this formula in is C32.
I keep getting circular reference error when I try to execute this formula with the If statement included. Attaching my circular reference error, I am unable to figure out what the circular reference is.