by Nate Moore | Jun 13, 2011 | Functions
Excel Video 165 uses the WEEKDAY function to calculate which days are weekends to help you figure out call. The only trick to the WEEKDAY function is deciding which day of the week you want to call day 1. I typically use option 2 so that Saturdays are given the value...
by Nate Moore | Jun 8, 2011 | Functions
DATEVALUE doesn’t get the tax returns of the date your daughter just introduced, but Excel Video 164 does show you how to use DATEVALUE to change text to a date. Just like Excel Video 162 changed text to values with the VALUE function, DATEVALUE changes text to a...
by Nate Moore | Jun 6, 2011 | Functions
NOW and TODAY sounds like the name of a bad soap opera, but they’re two functions to get the current date and time that we’ll discuss in Excel Video 163. The NOW function retrieves the computer’s date and time, while TODAY retrieves the computer’s date. Note that you...
by Nate Moore | Jun 1, 2011 | Functions
Excel Video 162 helps you convert text to values and values to text. Before Excel 2007, I used the VALUE and TEXT functions a lot more than I do now. I’ll show you what I do now to convert values to text and text to values, and then I’ll show you how to use VALUE and...
