Calculate Due Dates in slabs

S

Shanks

I have 3 dates within a month to make cheques,as per
Bills received. Below is the matrix for the same.

Received Paid on
23rd to 5th 10th
6th to 12th 18th
13th to 22nd 28th

Like wise the cycle goes on.

Now the problem is how do I put this in one formula which
will refer to Dates rows within Column B4 to Bx which
contain Bill Receipt Dates.

Need help asap

thks in adv
Shanks
 
J

jeff

Hi,

Try this formula and drag down:

=IF(OR(DAY(A2)>=23,DAY(A2)<=5),10,IF(AND(DAY(A2)>=6,DAY
(A2)<=12),18,28))

jeff
 
Top