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 […]

Overlooked uses MOD function

7 Overlooked Uses of Excel MOD Function

Crispo Mwangi | 7-Jun-16 | 10 Comments

In Over  450 functions in Excel, there are some powerful but highly underutilized functions and some overly popular functions too. 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 is part 1 of a […]