Z
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?
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?