To find the difference between two dates, you can subtract the older date from the newer one. That will return the difference in days; however, you might want it in weeks, months, or years. The little-known DATEDIF function is the perfect solution for this. You won't see any mention of it in Excel, as it's undocumented. However, its versatility prevents the need to construct long, windy formulas to achieve the same result, and therefore worth considering. Just make sure you use it responsibly… �

Excel VBA - Introduction

Cara Menggunakan Rumus VLOOKUP