more 1-2-3 converting

  • Thread starter Thread starter MrG
  • Start date Start date
M

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
 
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.
 
Back
Top