Working Days

[sohaibj]

I work in an oil field.
First 15 days (without any break, without any weekend or holiday) are my working days.
Just after every 15 days, I got a break of exactly 13 days. Then I again join my duty for next 15 days and this cycle goes on.
Now I want to calculate total working days between ANY two dates.
How can I do it?

 

[James006]

Hello,

Before jumping onto building a formula or an UDF ... you will need a reference point ...i.e the date of your first working day ...

Cheers