if cell is blank, then you might want to sum, count, copy a value from another cell, or do nothing. In these scenarios, ISBLANK is the right function to use, sometimes alone, but most often in combination with other Excel functions. ...
=IF(LEN([@[Data da Licença]])=0;\" \";DATEDIF( [@[Data da Licença]];TODAY();\"y\") & \" anos \" & MOD(DATEDIF([@[Data da Licença]];TODAY();\"ym\");12) & \" meses \" & MOD(MOD(DATEDIF( [@[Data da Licença]];TODAY();\"md\");...
=IF(LEN([@[Data da Licença]])=0;\" \";DATEDIF( [@[Data da Licença]];TODAY();\"y\") & \" anos \" & MOD(DATEDIF([@[Data da Licença]];TODAY();\"ym\");12) & \" meses \" & MOD(MOD(DATEDIF( [@[Data da Licença]];TODAY();\"md\");365);12) ...
‹ Tom’s Tutorials for Excel: How old are you? Undocumented DATEDIF Tom’s Tutorials for Excel: Workbook Suicide › 78 comments on “Tom’s Tutorials for Excel: Look up Intersecting Value by Row and Column Criteria” Simon Catich says: July 21, 2011 at 8:57 p...