Solved

Modifying DATEDIF formula if Column A is blank

Posted on 2014-03-25
5
2,103 Views
Last Modified: 2014-03-25
I am using the following DATEDIF formula to get the number of days in Column D:

=IFERROR(DATEDIF(B2,C2,"D"),"")

But sometimes there are blank cells in Column A and so it's causing errors in my calculations for those rows (1000's of days).

I'd like to be able to modify the above formula to include:

If A2 is blank, then D2 to be blank as well.

Thanks!
Andrea
0
Comment
Question by:Andreamary
  • 2
  • 2
5 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 39953857
Try

=IF(A2="","",ERROR(DATEDIF(B2,C2,"D"),""))

Thomas
0
 

Author Comment

by:Andreamary
ID: 39953875
Hi Thomas,

I'm getting an error message that highlights the word "ERROR" in the formula and says "that function not valid"...

Thanks,
Andrea
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39953878
My bad, should be iferror

=IF(A2="","",IFERROR(DATEDIF(B2,C2,"D"),""))
0
 
LVL 8

Expert Comment

by:itjockey
ID: 39953881
Change to IFERROR


Thanks
0
 

Author Closing Comment

by:Andreamary
ID: 39953894
That did the trick...thanks very much!
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now