 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Formula 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. hi try this one.. =IF(C1>0,C1+90,IF(D1>0,D1+60,"")) regards FSt1 > The reply I received suggested this formula... > =IF(COUNT(C1:D1),MAX(C1+90,D1+60),"") [quoted text clipped - 12 lines] > 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. >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)  SignatureBiff Microsoft Excel MVP > The reply I received suggested this formula... > =IF(COUNT(C1:D1),MAX(C1+90,D1+60),"") [quoted text clipped - 17 lines] > vertically and have it automatically calculate the forward date in E > column. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.