6 Replies Latest reply on Mar 28, 2016 1:53 PM by george dudley

    Emulate Excel Formula

    george dudley

      Hello,

      I am trying to emulate the phrase EOMONTH(TODAY(),0)+1 from Excel in Tableau and I can't seem to establish the End Of Month.

       

      Actually I am trying to emulate =IF(ISBLANK(L11),"",IF(EOMONTH(TODAY(),0)+1>EDATE(K11,0),IF(ISBLANK(K11),"No expiration","Verify"),"Correct")), but I think I can do the rest of it, I just can't get the EOM.

       

      Any help would be appreciated.

       

      Thanks, George