Data Analysis with Excel 📈📉📊✅ - 3 Powerful & Essential DATE formulas for finance people 📅💡⚡

Visit https://squarespace.com/chandoo to get 10% off your first purchase. Thank you Squarespace for sponsoring this video. ~==============================~ Do you work in Finance? Knowing how to use Excel's date functions is important for you. In this video, let me share three powerful date formulas for you. These are, 1) Quarter from date (both calendar & financial) 2) First working day of the month 3) Last working day of the month Timestamps: =========== 0:00 - Intro & Quarter from date 1:26 - First working day of the month 2:20 - Last working day of the month Sample file: ========== https://chandoo.org/wp/wp-content/uploads/2021/07/3-must-know-date-calculations-for-accountants.xlsx Learn more about dates & other Excel functions: ======================================= Using date & time values in Excel - a handy guide - https://chandoo.org/wp/date-time-tips-ms-excel/ Top 10 Excel formulas for data analysis - https://youtu.be/Q-XGJbHG8Vo Top 10 formulas for IT people - https://youtu.be/P7w6JeNS_SA #ExcelFormulas