| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula that change all date by putting in one date | Excel Worksheet Functions | |||
| putting date on spreadsheet | Excel Discussion (Misc queries) | |||
| I am putting in a date 02-10-06 and its coming up as 10-02-06 | Excel Worksheet Functions | |||
| Putting computer date in cell | Excel Discussion (Misc queries) | |||
| Putting the date as a sheet name | Excel Discussion (Misc queries) | |||
Hybrid Mode
