6 Replies Latest reply: Apr 17, 2012 4:14 AM by Anne Duffy RSS

    Date format text box

      Hi Guys,

       

      I have a text box formula and I wish for it to give me yesterdays dates , if yesterday was a weekday , if its not then give me fridays date.

      The following is correct where it comes to the Date part of it but it is resulting in 13/00/2012

       

      I have fluted around with it and always the Month is 000,

       

      Can anyone advise please ?

       

      =date(if(weekday(today()-1) * 1 <5,today()-1,today()-3),'dd/mm/yyyy')