calculate repair days

[Bruno_x]

I have column A with the date that a power tool has been reported as "to repair" and column B with the day the repaired tool was returned
I have to calculate the number of days that the machine was not present. But...

The broken machines are only collected on Tuesdays and Thursdays
So, a machine reported on thursday, friday or monday will be collected on the next tuesday. A machine reported on tuesday or wednesday will be collected the next thursday.

I can use 7 nested IF formulas, but there might be a better way to calculate the number of days...

Book1
	E	F	G
23	report	return	days
24	2/02/18	13/02/18	7
25	3/02/18	13/02/18	7
26	4/02/18	15/02/18	9
27	5/02/18	13/02/18	7
28	6/02/18	13/02/18	5
29	7/02/18	15/02/18	7
30	8/02/18	20/02/18	7
31	9/02/18	20/02/18	7
32	10/02/18	20/02/18	7
33	11/02/18	21/02/18	8
34	12/02/18	20/02/18	7
35	13/02/18
36	14/02/18
37	15/02/18
Blad1

 

[maninweb]

Hi there,

first, thanks for using my formula translator

Yes, unfortunately, the online translator is not able to translate array constants in formulas for many language pairs. This, as it is difficult to reverse the logic Excel is using for that.
Needs a lot testing in several languages and is very time consuming. So, for example, Excel mostly - but not always - uses the list separator for vertical arrays and dots, commas
or backslashes for horizontal arrays. Depends as far as I can currently see on the Windows Language and the Excel Language and then, also differs, if it matches the Windows
Language or not.

However, I am working on that and I hope to be able to publish an update in the coming 2-3 months,
after the redesign of the website, which is also currently in progress.

Best,
Mourad