Last week I explained how Excel uses its own, unique system of serial numbers to calculate dates and times. That piece covered nine Date & Time functions: NETWORKDAYS(), DATEVALUE(), NOW(), DAY(), ...
Have you ever found yourself wrestling with Excel, wishing it could just do *that one thing* to make your work easier? Maybe you’ve spent hours manually replacing text, trying to filter data with ...