Category: TEXT

Jan8 date format

Format a date in shortest format possible indicating how many days have passed (Past date) If date1-date2 < 8 Sat, Fri, …If date1-date2 < 350...

6174 Kaprekar’s constant

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads...

DayName

Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only...

Zipcode-State search

Enter a zip code, and Excel will tell you in which state it is It also has a list of all zip codes for all...