Hello,
Can any one tell me what is the problem in my formula. I am trying to find the no. of days in between 2 dates. But in some cells it is giving error #NUM!
I am using the formula =DATEDIF(NOW(),B2,"d") or =IF(ISNUMBER(B2),DATEDIF(B2,NOW(),"d"),"").
Sample file is attached for your reference.
Bookmarks