Date and Time Functions Playlist
Excel Video 163 NOW and TODAY
NOW and TODAY sounds like the name of a bad soap opera, but they’re two functions to get the current date...
Excel Video 164 DATEVALUE
DATEVALUE doesn’t get the tax returns of the date your daughter just introduced, but Excel Video 164 does...
Excel Video 165 WEEKDAY
Excel Video 165 uses the WEEKDAY function to calculate which days are weekends to help you figure out call. ...
Excel Video 167 Using TODAY, DATE, YEAR, and MONTH to Automatically Update a Rolling Report
When we last left our heroes in Excel Video 166, we had a clever formula that automatically updated after...
Excel Video 168 TIME
Make the most of your TIME by watching Excel Video 168. I’ll cover three time related functions in this...
Excel Video 169 Time to Format Times
The time formatting we reviewed in the last Excel Video has a catch we’ll discuss in Excel Video 169. As...
Excel Video 170 HOUR, MINUTE, and SECOND
It won’t take HOURs to explain HOUR, MINUTE, and SECOND in Excel Video 170. All three functions are very...
Excel Video 192 Convert Minutes to Hours:Minutes
When you see =INT(A16/60)&":"&IF(LEN(MOD(A16,60))=1,"0"&MOD(A16,60),MOD(A16,60)) in Excel Video 192, you’ll...
