This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.