Join 400,000+ professionals in our courses here 👉 [ Ссылка ]
This video demonstrates how to efficiently create timelines and timetables in Excel, particularly useful for project management and finance reporting.
⬇️ Download the workbook here: [ Ссылка ]
🛠 Key Feature: The Workday Function
- Functionality: Calculates end dates based on a start date and the number of working days, excluding weekends and holidays.
- Usage Scenarios: Ideal for project time plans or finance reporting timetables.
📅 Examples Illustrated:
- Project Management: For a task starting on a specific date, the video shows how to calculate the completion date considering working days, weekends, and holidays.
- Finance Reporting: Demonstrates setting up monthly reporting deadlines based on working days of each month.
👩💻 Steps Highlighted:
- Input Start Date and Working Days: Input the task's start date and the number of required working days.
- Apply Workday Function: Use Excel's 'Workday' function to compute the end date, excluding weekends and holidays.
- Consideration of Weekends: The standard Workday function assumes weekends are Saturday and Sunday, but 'Workday International' allows customization of weekend days.
- Practical Usage: The video includes a calendar to validate the function's accuracy and an example of custom formatting to display only the month and year in a cell while retaining the complete date.
🔍 Additional Features:
- Auto-Filling Dates: Shows how to drag the formula across other cells for automating date calculations for multiple tasks.
- Customization for Local Holidays: Includes how to incorporate local holidays into the calculation for more precise planning.
- Flexibility for Different Scenarios: Adapts to various project and reporting needs by altering the start dates and working days.
Excel's workday function is great when you need to calculate an end date based on a given number of working days - which means you need to exclude weekends and holidays. Some examples are
- creating a project timeline
- creating a reporting timetable
In this video I show you both examples.
Excel's workday function assumes weekends fall on Saturdays and Sundays. In case the weekends in your country fall on other days, you will need to use Workday.intl where you have an additional option to select the weekend days.
★ My Online Excel Courses ► [ Ссылка ]
➡️ Join this channel to get access to perks: [ Ссылка ]
👕☕ Get the Official XelPlus MERCH: [ Ссылка ]
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: [ Ссылка ]
🎥 RESOURCES I recommend: [ Ссылка ]
🚩Let’s connect on social:
Instagram: [ Ссылка ]
LinkedIn: [ Ссылка ]
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
