In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory, ...

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the future. Whether you need to calculate end-of-month due dates, deadlines, ...

As you create Excel spreadsheets for your small business, time and date functions frequently add both convenience and programming capability to your workbooks. There's good news with date functions.

Creating a series of random dates in Excel allows you to test your spreadsheet's functions on a variety of dates or look at projections for a range of future dates. Excel has a built in random number ...

The simplest way to add an apostrophe before a date in Excel is to type it directly before the date when entering it in a cell. This method works best when you’re dealing with a small number of ...

If you are looking to improve your financial modelling skills when using Microsoft Excel spreadsheets you might be interested in this quick overview guide that provides an in-depth exploration of the ...

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel. Weekends and holidays are important to most of us. Besides enjoying the ...