i
In our payroll we have pay numbers that falls into biweekly pays.
ex: pay 1 Dec 25 Jan 7/17
Pay 2 Jan 8 Jan 21/17
I want a formulas that says:
if someone worked between Dec 25 and Jan 7/17 give me 2 (for pay)
if someone worked between Jan 8 and Jan 21/17 give me 3 and so on and on
Update
something like this - but without the * before the secon if
=IF(OR(F11>=C11,F11<=E11),B12,"")*IF(OR(F11>=C12,F11<=E12),B13,"")