 |
 | 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 / New Users / December 2007Need Formula
I need help with a formula for Cell E3 that will give me the total days between cell C3 and D3 - Here's what I am trying to do. Column C3 - Enter Deployment Start Date Column D3 - Enter Deployment Return Date Column E3 - Total Days Deployed As of now I am using =SUM(D3-C3) but it does some strange things. If only C3 or D3 are filled in it gives a bogus number until both cells are filled in. Also it always displays the number zero unless a value is entered - I would rather the cell remain blank if cells C3 and D3 are blank. Thanks Try this: E3: =IF(COUNT(C3:D3)=2,D3-C3,"") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) >I need help with a formula for Cell E3 that will give me the total days > between cell C3 and D3 - Here's what I am trying to do. [quoted text clipped - 13 lines] > > Thanks Ron - That is perfect Thanks Can you answer one more thing ? In my date cells I am I set the format to date - but is there a way that if the date is entered without the slashes between the dd/mm/yyyy that it will automatically do it ? Thanks > Try this: > [quoted text clipped - 26 lines] > > > > Thanks See this: http://www.cpearson.com/Excel/DateTimeEntry.htm  SignatureBiff Microsoft Excel MVP > Ron - That is perfect Thanks > [quoted text clipped - 38 lines] >> > >> > Thanks You don't need the SUM function. Give this a try... =IF(OR(C3="",D3=""),"",C3-D3) Rick >I need help with a formula for Cell E3 that will give me the total days > between cell C3 and D3 - Here's what I am trying to do. [quoted text clipped - 13 lines] > > Thanks Damn! I have the D and C columns reversed... =IF(OR(C3="",D3=""),"",D3-C3) Rick > You don't need the SUM function. Give this a try... > [quoted text clipped - 19 lines] >> >> Thanks Sat, 15 Dec 2007 20:19:00 -0800 from George <George@discussions.microsoft.com>: > I need help with a formula for Cell E3 that will give me the total > days between cell C3 and D3 - Here's what I am trying to do. > Column C3 - Enter Deployment Start Date > Column D3 - Enter Deployment Return Date > Column E3 - Total Days Deployed > As of now I am using =SUM(D3-C3) but it does some strange things. Lose the SUM function. You're doing a straight subtraction. > If only C3 or D3 are filled in it gives a bogus number until both > cells are filled in. Well, of course. How could it be otherwise? But you can solve this problem along with the other one you mentioned: > Also it always displays the number zero unless a value is entered - I > would rather the cell remain blank if cells C3 and D3 are blank. =if(and(C3>0,D3>0),D3-C3,"") SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/
|
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.