Date Functions

[mashburn]

I am using the following formula to calculate workdays over due.
G6 has the issue identification date
H6 has the formula =workday(g6,5) which is the target date
I6 has the issue closed date
J6 has the formula =IF(ISBLANK(I6),NETWORKDAYS(H6,TODAY()),NETWORKDAYS(H6,I6)-1)
Since I am prepopulating my sheet with these formulas how do I avoid a 28962 number in cell J6 and keeping my conditional formating (RYG icons)

 

[MisterBate5]

I usually propogate the blanks:
=if(isblank(g6),"",workday(g6,5))
=if(isblank(g6),"",IF(ISBLANK(I6),NETWORKDAYS(H6,TODAY()),NETWORKDAYS(H6,I6)-1))

 

[mashburn]

thanks that worked like a charm