This is the formula that I am using "=IF(DATEDIF(C7,D7,"d")=0,"",DATEDIF(C7,D7,"d"))" , (It works and I get the result that I am looking for), but what is happening is when I enter the date in C7 I get "#NUM!" in E7 before I enter the second date in D7. If I did not want to see the "#NUM! result in E7 before I enter the date in D7, what would the formula have to be? Any help on this would be appreciated. Thank you in advance.
Roco
Hi
first attempt:
=IFERROR(IF(DATEDIF(C7,D7,"d")=0,"",DATEDIF(C7,D7,"d")),"")
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Or maybe this...
=IF(OR(C7=0,D7=0),0,DATEDIF(C7,D7,"d"))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks