Excel: How to Calculate the Date of the Last Friday (Or Any Other Day) of Every Month

Got a crucial deadline or special day to track each month? Whether it's pay day, expense submission day, or any other key date, calculating the date of the last Friday (or any day) of the month is a common task in Excel and in this tutorial, I'll walk you through a practical, step-by-step example of how to perform this task.
This video is perfect for intermediate Excel users looking to enhance their skills in date calculations. Get ready to make your monthly planning smoother and more efficient with these Excel tricks!
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/...
The formulas that I used in the demos:
=EOMONTH(DATE($A$1,C2,0))
=TEXT(C3,"DDDD")
=XLOOKUP(C4,$B$14:$B$20,$C$14:$C$20)
=C3-C5
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltraine...
🙋‍♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #dates #lastfriday

[@peterwilliamson3423]

Great Video Mike, is it possible to do something similar to list every second Friday in the month?

[@pandamonium9834]

More magic 👍👀🐼. Thank you Mike

[@marthinlarsen1473]

Great video

[@MikeThomas67]

Glad you enjoyed it

[@marthinlarsen1473]

@MikeThomas67 your videos are very helpful, and I'm positively surprised to see your skills in Excel on MacOS.
I'm considering buying a laptop to study finans, but rumours have it. Excel doesn't work as well with MacOS compared to Windows.
This is critical for any respectable PC, I think. Well, it seems it works just fine, thanks to your videos.