putting in date ranges

[ZIPPOMA NEEDS HELP]

I am putting Bi Weekly cycles into cells A1 B1 C1 for Oct
I am Putting Bi Weekly cycles into cells A2 B2 C2 for Nov
A1= Oct 4 and the rest of the cells will be a copy of the previous one +14
ie +A1+14

Now the question is..if the 3rd date is in Oct I want it to go into C1 or if
it is in Nov as it would be in this case I want it to go into A2 leaving C1
blank. If I just use the same formula it would put Nov 1 in C1 which I dont
want.

Is there any way to do this?

 

[Stefi]

Enter in B1 =A1+14
in C1 =IF(MONTH(B1+14)=MONTH(A1),B1+14,"")
in A2 =IF(MONTH(B1+14)=MONTH(A1),C1,B1)+14
and fill them down as required!

Regards,
Stefi

„ZIPPOMA NEEDS HELP†ezt írta: