WEEKDAY function

Excel’s WEEKDAY Function In depth

Crispo Mwangi | 8-Jun-16 | Leave a Comment

Today we shall have an in-depth look at another underutilized yet powerful function, especially when analyzing dates–WEEKDAY. I hope Part 1 of this series made you get acquainted with MOD function and it has become a favorite for you. Below are some of the uses of WEEKDAY function: Summarize by weekday or weekend Count-if by […]

7 Overlooked Uses of Excel MOD Function

Crispo Mwangi | 7-Jun-16 | 10 Comments

In Over  450 functions in Excel, MOD function is one of the highly overlooked. Generally, MOD function returns the remainder of two numbers after division. Functions like IF, SUM, COUNT, AVERAGE are well known by all excel users. Yet there are some functions like MOD, WEEKDAY, WORKDAY, CHOOSE, DATEDIF, DELTA, SUBSTITUTE, HYPERLINK are rarely used. This […]