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.
Get the Latest Microsoft Excel Tips

Follow Us
Follow us on social media to stay up to date with the latest in Microsoft Excel!