Calculation to work out the date of each day in the current week
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.
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.
thisWeeksTuesday....... etc etc
I basically want to have 5 seperate reports or portals which are filtered by each day: Monday, Tuesday, Wednesday, Thursday, Friday