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
Негізгі бет Excel: How to Calculate the Date of the Last Friday (Or Any Other Day) of Every Month
Пікірлер: 5