How can you calculate the difference between two dates in Excel? And what if you also want to create calculations with dates and exclude weekends and possibly holidays? Let’s look at two Excel functions, WORKDAY and NETWORKDAYS, that will help you to create calculations with dates that only include working or business days.
by Melissa Esquibel, MCT We’re not getting any less data. That’s for sure! But, unfortunately, the quality of the data we’re getting isn’t improving at the same rate. Here are a 3 tips to turn the stuff you get into something you can use. Banish Leading and Trailing Spaces One of the tasks you may…
by James Spellos, CMP, MOS As you continue to learn more about Excel, the area where quantum leaps of productivity take place is in using functions. Everyone (at least everyone reading this) is well aware of the most basic function, @SUM. At the core of what Excel does, this function allows you to perform math…
IAAP Edge 