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 Dec24, Jan4, Aug14Else 2020Feb4
Return 12 values in one number
A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12 items, and you want a …
Cells with additional spaces
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)
Highlight dates dynamically
Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can …
IF with AND and IF with OR
The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or OR functions. Also, once we …