DateTime Value

How to Update Date or Time in EXCEL

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

To update/extract the date or Time part separately in a DateTime Value is a lot easier  if you understand that excel stores dates as sequential serial numbers and time as a fractional portion of a 24 hour day. With the above understanding, you can combine INT and MOD functions to perform calculations on or extract the […]

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