I need help please to fix below formula.
IF(AE2="",TODAY()-D2,NETWORKDAYS.INTL(D2,AE2,1,$AJ$2:$AJ$15)-1-MOD(D2,1)+MOD(AE2,1))
AE is the close date
D2 is the receive date.
when AE (close date) is empty it calculates the number of days and ignores the second part of the formula so it is not removing the weekend and public holidays. it only considers first part (when close data is empty it calculates the age based on today's date - received date) and doesn't remove the weekends in the second part of the formula.
Thank you.
