Hello,
I have a WORKDAY.INTL function that returns a due date given parameters (thanks DRSteele). Now I am trying to conditionally format the cell so that the default return date (Wednesday February 29, 1900) is invisible. I have tried conditional formatting as a date, as number, as text will no luck.
Any thoughts
Here is the formula
=IF(WEEKDAY(WORKDAY.INTL(D3,60,"0000000",C18:C102),2)+IF(D4<=8,0,D4-8)=6,IF(D4<=8,0,D4-8)+WORKDAY.INTL(D3,60,"0000000",C18:C102)-1,IF(WEEKDAY(WORKDAY.INTL(D3,60,"0000000",C18:C102),2)+IF(D4<=8,0,D4-8)=7,IF(D4<=8,0,D4-8)+WORKDAY.INTL(D3,60,"0000000",C18:C102)-2,IF(D4<=8,0,D4-8)+WORKDAY.INTL(D3,60,"0000000",C18:C102)))
I have a WORKDAY.INTL function that returns a due date given parameters (thanks DRSteele). Now I am trying to conditionally format the cell so that the default return date (Wednesday February 29, 1900) is invisible. I have tried conditional formatting as a date, as number, as text will no luck.
Any thoughts
Here is the formula
=IF(WEEKDAY(WORKDAY.INTL(D3,60,"0000000",C18:C102),2)+IF(D4<=8,0,D4-8)=6,IF(D4<=8,0,D4-8)+WORKDAY.INTL(D3,60,"0000000",C18:C102)-1,IF(WEEKDAY(WORKDAY.INTL(D3,60,"0000000",C18:C102),2)+IF(D4<=8,0,D4-8)=7,IF(D4<=8,0,D4-8)+WORKDAY.INTL(D3,60,"0000000",C18:C102)-2,IF(D4<=8,0,D4-8)+WORKDAY.INTL(D3,60,"0000000",C18:C102)))
