This formula will return the weekday for a given date.

#### How To Get The Percent Of The Month Completed

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

#### How To Do A Case Sensitive Lookup

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.

#### How To Sum All Odd Numbers In A Range

This formula will sum all the odd numbers from a given range of values. An odd number is defined as any number that has a remainder of 1 when divided by 2.

#### How To Sum All Even Numbers In A Range

This formula will sum all the even numbers from a given range of values. An even number is defined as any number that has a remainder of 0 when divided by 2.

#### How To Count All Odd Numbers In A Range

This formula will count all the odd numbers from a given range of values. An odd number is defined as any number that has a remainder of 1 when divided by 2.