Excel: How to Calculate the Date of the Last Friday (Or Any Other Day) of Every Month скачать в хорошем качестве

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: https://app.box.com/s/k1wp7ck7uiz24ar... 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 https://theexceltrainer.co.uk 🙋‍♂️ Let's connect on social Twitter:   / theexceltrainer   Facebook:   / theexceltrainer   LinkedIn:   / thomasmik   #excel #dates #lastfriday