I have a calculated column to determine the number of days between Introduction call date and Today's date. It works fine as long as the introduction call date is less or equal to Today's date but getting a error when it is above today. Please help with the correct formula.
The formula that I use is below and 27 days is the target days, whereby the timeline starts at -27 decrements each day.
=IF([Implementation Status]="COMPLETE",(DATEDIF([Introduction Call date],[Status Date],"D"))-INT(DATEDIF([Introduction Call date],[Status Date],"D")/7)*2-IF(WEEKDAY([Status Date])<WEEKDAY([Introduction Call date]),2,IF(OR(WEEKDAY([Status Date])=7,WEEKDAY([Introduction Call date])=1),1,0))+1-(27),(DATEDIF([Introduction Call date],[Today's Date],"D"))-INT(DATEDIF([Introduction Call date],[Today's Date],"D")/7)*2-IF(WEEKDAY([Today's Date])<WEEKDAY([Introduction Call date]),2,IF(OR(WEEKDAY([Today's Date])=7,WEEKDAY([Introduction Call date])=1),1,0))+1-(27))