In this video I demonstrate how to find and select a cell containing today’s date. I explore two methods. The first method uses the HYPERLINK, MATCH and TODAY functions within a single formula, and the second method uses a VBA macro. Click here to download the featured file. Table of Contents 00:00 – Introduction 00:16… Read More »Jump to Today’s Date in Excel | Hyperlink Formula or VBA Macro to Find Today’s Date in Worksheet

  In this video tutorial I explain how to keep a chart visible when scrolling up or down through a worksheet.  I explore two methods: Click here to download the featured file (including code) Video Table of Contents 00:00 – Introduction 00:18 – METHOD 1: Freeze Panes 00:49 – METHOD 2: VBA – see code… Read More »How to Keep a Chart (or Charts) Visible when Scrolling in Excel?

So you want Excel to generate a list of all dates between two dates.  This video demonstrates three ways you can achieve this. Click here to download the featured file (including code) Method 1: Using the SEQUENCE Function Click here to see this part of the video Here’s the formula used in the video: =C2+SEQUENCE(C3-C2+1,,0)… Read More »List All Dates Between Two Dates in Excel | One VBA Macro Method and Two Formula Methods