This formula will add leading zeros to a given number up to a specified number of total characters in the result.

This formula will return the percent of the year completed for a given date.

This formula will test a given date to see if it’s a weekend (Saturday or Sunday) and return TRUE if it is a weekend and FALSE if it is not a weekend.

This formula will return the weekday for a given date.

This formula will return the percent of the month completed for a given date.

This formula will perform a vertical case sensitive lookup in a given range of values and return a result from the corresponding cell in another range. The functionality of this formula is similar to the VLOOKUP function, however VLOOKUP does not differentiate between upper and lower case letters when looking for a match. To VLOOKUP “AAA” and “aaa” would be the same thing.