I am counting the days between two dates. The formula I am using in column C is =DATEDIF(A2,B2,"D"). My problem is, column B does not always contain a date. If there is no date in column B, I want a blank cell in column C. Currently, I am getting the error #NUM.
I have tried =ISERROR(DATEDIF(A2,B2,"D"),"",DATEDIF(A2,B2,"D"), but I am doing something wrong in the formula, as I continue to get a pop-up error box. One pop-up error box says I've entered too many arguements for the function.
In Excel 2010 you can use IFERROR like this
=IFERROR(DATEDIF(A2,B2,"D"),"")
....but in fact to get the difference in days between 2 dates you can simply subtract the earlier date from the later one so this formula should also work
=IF(B2="","",B2-A2)
format result cell (C2) as general
Audere est facere
=IFERROR(Your formula,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks