Data Validations:
Checking whether the cell has a number or not, usually useful while checking accounts/transactions/banking sheets.
=(F2-(IF(ISNUMBER(D3),D3,0))) + (IF(ISNUMBER(E3),E3,0))
Checking whether the cell is BLANK, usually useful in textual/string validations
=(F2-(IF(ISBLANK(D3),D3,0))) + (IF(ISBLANK(E3),E3,0))
Conversions:
Date values: India to US
Input Date Format: 7/1/2011 (days in single digits)
Conversion Formula: DATE(YEAR(B3),DAY(B3),MONTH(B3))
Output Date Format: 1/7/2011
Input Date Format: 14/01/2011 (days in two digits)
Conversion Formula: DATEVALUE(MID(B8,4,2)&”/”&LEFT(B8,2)&”/”&RIGHT(B8,3))
Output Date Format: 1/14/2011
Reference articles:
