|
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 |
putting in date ranges
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: 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 |
| All times are GMT +1. The time now is 11:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com