AnsweredAssumed Answered

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

Question asked by jonnyt on Feb 1, 2011
Latest reply on Feb 8, 2011 by 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

Outcomes