Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help needed
The reply I received suggested this formula... =IF(COUNT(C1:D1),MAX(C1+90,D1+60),"") Many thanks and I carefully tried it but did not completely work. Maybe I confused the issue... In column C, if there is a date in C1 or C2 or C3 or C4 and on down say thru C30, I wish to add 90 days & have the date put in the corresponding E cell, ie C20 answer in E20. In column D, if there is a date in D1 or D2 or D3 or D4 and on down say thru D30, I wish to add 60 days & have the date put in the corresponding E cell. There would not be a date in C1 and D1 at the same time. MANY MANY thanks for your help David This is a spreadsheet where we would enter a date in either C Or D column vertically and have it automatically calculate the forward date in E column. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help needed
hi
try this one.. =IF(C10,C1+90,IF(D10,D1+60,"")) regards FSt1 "caseysmydog" wrote: The reply I received suggested this formula... =IF(COUNT(C1:D1),MAX(C1+90,D1+60),"") Many thanks and I carefully tried it but did not completely work. Maybe I confused the issue... In column C, if there is a date in C1 or C2 or C3 or C4 and on down say thru C30, I wish to add 90 days & have the date put in the corresponding E cell, ie C20 answer in E20. In column D, if there is a date in D1 or D2 or D3 or D4 and on down say thru D30, I wish to add 60 days & have the date put in the corresponding E cell. There would not be a date in C1 and D1 at the same time. MANY MANY thanks for your help David This is a spreadsheet where we would enter a date in either C Or D column vertically and have it automatically calculate the forward date in E column. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help needed
I carefully tried it but did not completely work.
Can you explain what "did not completely work" means? What results do you expect with these dates: ................C.................D............... E..... 1......1/1/2008..................................... 2.........................2/27/2008................ 3.....3/13/2008.................................... Based on your explanation the formula returns these results: E1 = 3/31/2008 (C1+90) E2 = 4/27/2008 (D2+60) E3 = 6/11/2008 (C3+90) -- Biff Microsoft Excel MVP "caseysmydog" wrote in message ... The reply I received suggested this formula... =IF(COUNT(C1:D1),MAX(C1+90,D1+60),"") Many thanks and I carefully tried it but did not completely work. Maybe I confused the issue... In column C, if there is a date in C1 or C2 or C3 or C4 and on down say thru C30, I wish to add 90 days & have the date put in the corresponding E cell, ie C20 answer in E20. In column D, if there is a date in D1 or D2 or D3 or D4 and on down say thru D30, I wish to add 60 days & have the date put in the corresponding E cell. There would not be a date in C1 and D1 at the same time. MANY MANY thanks for your help David This is a spreadsheet where we would enter a date in either C Or D column vertically and have it automatically calculate the forward date in E column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
needed formula | Excel Worksheet Functions | |||
Formula Set Up Needed | Charts and Charting in Excel | |||
= if formula needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions |