replication of formula from SAP BO Reports

[Bart_Esz]

Dear All,

I have to replicate a formula that is used in SAP BO Reports which returns a numeric value, the formula is given below. 

I was trying many different ways, but I'm not able to progress as I don't really understand some of the function nested in the maim formula.

A big request to that can give me some tips on how to solve it.

If you need any additional information, please let me know.

many thanks and regards

'=DaysBetween(RelativeDate([Created On Date];Floor(DayNumberOfWeek([Created On Date])/6)*(8-DayNumberOfWeek([Created On Date])));RelativeDate(CurrentDate();Floor(DayNumberOfWeek(CurrentDate())/6)*(8-DayNumberOfWeek(CurrentDate()))))-(Floor(DaysBetween(RelativeDate(RelativeDate([Created On Date];Floor(DayNumberOfWeek([Created On Date])/6)*(8-DayNumberOfWeek([Created On Date])));(DayNumberOfWeek(RelativeDate([Created On Date];Floor(DayNumberOfWeek([Created On Date])/6)*(8-DayNumberOfWeek([Created On Date]))))+1)*-1);RelativeDate(CurrentDate();Floor(DayNumberOfWeek(CurrentDate())/6)*(8-DayNumberOfWeek(CurrentDate()))))/7)*2)

[Luke_C]

@Bart_Esz Can you give some sample data? Will be helpful to see the various fields used in the formula + expected results.