Forum Discussion

bonny666's avatar
bonny666
Icon for Helper I rankHelper I
7 years ago

result based on TODAY() is not being updated

In my source excel there's the following formula:    =IF(Till="","", IF(DATEDIF(Till,TodayDate,"y"), DATEDIF(Till,TodayDate,"y")&"y ","")& IF(DATEDIF(Till,TodayDate,"ym"), DATEDIF(Till,TodayDate,...