Find Nth Weekday in Month Excel Date Functions

Опубликовано: 05 Октябрь 2024
на канале: Contextures Inc.
5,387
73

Find Nth weekday in a specific month and year, with Excel formula. For example, Canadian Thanksgiving - 2nd Monday in October, for current year.

Watch this video to see the steps.

Visit my site for more details, and to get the sample file with flexible formulas
https://www.contextures.com/exceldate...

Or use this short link: https://myctx.link/NthDay

Video Timeline

00:00 Introduction
00:24 Find Nth Weekday
00:50 Start the Formula
01:53 Weekend Days
02:54 How It Works
03:15 Flexible Formula