more 1-2-3 converting

[MrG]

I tried to make this one into Excel
@IF(@ISEMPTY(AT24)#AND#@ISEMPTY(AX24);"";@IF(@ISEMPTY
(AT24);@DAYS(AX24;@TODAY);@DAYS(AX24;AT24)))

whereas 2003-10-14 is the content of AV column..

Does anyone have a clue how to translate this into Excel
language?

Help is appreciated.

Mr.G

 

[rbrychckn]

I have absolutely no understanding of 123, but guessing on what you have
above, here is a place to start.

=IF(AND(ISBLANK(AT24),ISBLANK(AX24)),"",IF(ISBLANK(AT24),DAYS360(AX24,TODAY()),DAYS360(AX24,AT24)))

I am assuming with the DAYS function, you are trying to calculate the
days between the two dates given.