Download the featured file here: https://www.bluepecantraining.com/jump-to-todays-date-in-excel-hyperlink-formula-or-vba-macro-to-find-todays-date-in-worksheet/

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.

Table of Contents:

00:00 - Introduction
00:16 - Formula method using HYPERLINK, MATCH & TODAY
05:07 - VBA macro with button method

Here's the code used in the video:

Sub Select_Today()
On Error GoTo ErrorHandler
Cells.Find(Date).Select
Exit Sub
ErrorHandler:
MsgBox "Today's date was not found"
End Sub
------------------------