4 Replies Latest reply: Jul 12, 2011 1:12 PM by Rodrigo Almeida RSS

    LASTWORKDAY with TimeStamp

      Hi guys,

       

      I'm using lastworkday function but it does not work ok with time stamp.

      I want to know the date with time from here 3 days in future.

       

      Exemple:

      =timestamp(lastworkdate (timestamp(now()), 3))

       

      It's 15h30 in Portugal.

      So.... the expression should be 15-07-2011 15:30:00

      But... the expression returns 15-07-2011 00:00:00

       

      Why??????

       

      Thanks for your help.

      Regards,

      Rodrigo.