In the topic below, the user asked the question how to calculate number of days between two dates and how to handle blanks. The solution was to use days.
Just asking the users of this forum, any preference between days versus datedif?
Also, I guess I never ran into this until recently, isblank isn’t always the solution, specifically if the cell contains a formula. Searching for a consistent, flexible, long-term solution, I found the functions below. I prefer isblank for its’ clarity. But if the spreadsheet starts out with hardcodied values, but later become functions as it develops, this could create problems that are not obvious at first. Thoughts?
=len(trim(c1))=0
=AND(c1 <> "",IF(ISERROR(VALUE(LEFT(c1))),0,1))Topic: