View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ZIPPOMA NEEDS HELP ZIPPOMA NEEDS HELP is offline
external usenet poster
 
Posts: 9
Default putting in date ranges

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?

--
Thanks Everyone
Mike