?
Solved

Modifying DATEDIF formula if Column A is blank

Posted on 2014-03-25
5
Medium Priority
?
3,229 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 total points
ID: 39953878
My bad, should be iferror

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

Expert Comment

by:Naresh Patel
ID: 39953881
Change to IFERROR


Thanks
0
 

Author Closing Comment

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

Featured Post

ATEN's HDBaseT Presentation at InfoComm 2017

Hear ATEN Product Manager YT Liang review HDBaseT technology, highlighting ATEN’s latest solutions as they relate to real-world applications during her presentation at the HDBaseT booth at InfoComm 2017.

Question has a verified solution.

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

This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

801 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