2 Replies Latest reply on Feb 8, 2011 9:54 AM by jonnyt

    Calculation to work out the date of each day in the current week

    jonnyt

      Title

      Calculation to work out the date of each day in the current week

      Post

      I am UK based and have a date format of DD/MM/YYYY

      Can anyone help me with a calculation as follows:-

      I need to work out the date of each working day in the current week.


      For example:-
      Todays Date is: 01/02/2011 and Today is Tuesday
      Monday = 31/01/2011
      Tuesday = 01/02/2011
      Wednesday = 02/02/2011
      Thursday = 03/02/2011
      Friday = 04/01/2011

      Calculations can be in seperate fields so that there is one field per day calculation. 

      i.e.

      thisWeeksMonday
      thisWeeksTuesday....... etc etc

      I basically want to have 5 seperate reports or portals which are filtered by each day: Monday, Tuesday, Wednesday, Thursday, Friday