Excel Magic Trick 1146

Create ISO Dates using TEXT function and Custom Number Format

DESCRIPTION

See how to:
1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”)
2. Compare two columns of formulas to check if results are equivalent using Logical Formula and COUNTIFS function.

WORKBOOKS