Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format

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.

[excelisfun]

Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format
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.

[KeithDuchnicki-ib]

Nine years old, yet this was just the answer I needed! Go Team!!

[machinista]

Simpler way to check the formulas, if you don't need to count errors but only check if there is any, is to use AND function on the range. Result would be TRUE if all cells in the range are TRUE.

[alancrook]

Is there a way to reverse  the process so an ISO input can be formatted to dd/mm/yy ddd  ? 

[leonidkoyfman]

Do you know why =TEXT(A7, "yyyymmdd")*1 entered in B7 retutns but
with =TEXT(A7, "yyyymmdd") entered in B7 we can use formula =B7*1 in any cell without errors?

[Simon-ounj]

Nice but what about ISO year? Date 2016-01-01 according to ISO should be year 2015 week 53Week number you can get by formula weeknum(A1;21) or ISOWEEKNUM(A1) for excel 2013 - A1 is cell with date of courseBut what about year? I discovered once formula like below, maybe it will help full year week