0:00
in this quick tutorial I'll show you how
0:01
to create dynamic hyperlinks in Excel
0:03
that let you jump directly to today's
0:05
day of the week and the current month of
0:07
the year it's a simple yet powerful
0:09
trick to navigate your data efficiently
0:11
type Sunday in A1 and drag the fill
0:14
handle to A7 for weekdays then type
0:17
January in C1 and drag to C12 for months
0:21
now let's add hyperlinks to jump
0:22
directly to today's day and month in a
0:25
blank cell type the formula as shown on
0:27
the screen this creates a clickable link
0:30
link clicking it takes you to the
0:31
current day in the range A1 to A7 the
0:34
formula combines the weekday function
0:37
which returns a number from 1 to 7
0:39
representing the current day of the week
0:40
with the cell reference to build a
0:42
dynamic Lake next for the months use
0:44
this formula clicking this link jumps to
0:46
the current month in the range C1 to C12
0:50
here the month function returns a number
0:52
from 1 to 12 for the current month
0:54
dynamically linking to the appropriate
0:56
cell in column C and that's it
