This video explains, how to add only working days in a Project Start date (excluding Saturday, Sunday and Holidays or Sunday only and Holidays) by using Workday and Workday.Intl Functions. This is useful to calculated Projected date for projects.
Add Weekdays/Working Days in a Date by excluding Weekends & Holidays | Date Function - Part 4
=WORKDAY(C4,D4,I4:I14)
=WORKDAY.INTL(C4,D4,11,I4:I14)
Playlist :-
Playlist : / theofficecrew
Excel Home Tab/Menu Playlist : • MS Excel - Home Tab , ...
Conditional Formatting Playlist : • Conditional Formatting...
Formula and Functions in Excel Playlist : • Top 7 Most Important M...
Videos :-
Excel Discussion over Zoom Meeting : • Excel Discussion - Zoo...
Mail Merge - Send 1000 mails in 1 minute : • Mail Merge - 1000 Emai...
Generate Certificates in Bulk : • Mail Merge : Create Ce...
Use Your Phone as Laptop : • Use Your Phone as Lapt...
7 Basic Excel Formulas/Functions : • Top 7 Most Important M...
We always provide useful content on The Office Crew RU-vid channel, here are MS Excel tips and tricks along with the computer related useful information in simple language and examples. It is our effort to get this information useful for all types of Excel users, computer users and internet users.
Tags - computer user,learn computer,hindi technology,internet user,excel user,ms office user,computer hindi, The Office Crew ,Sachin Tanwar,excel shortcuts,excel keyboard shortcuts,excel shortcut,excel shortcut keys,learn excel,excel tips,ms excel shortcut keys,microsoft excel,computer,laptop,computer tips & tricks,technology,keyboard,कम्प्यूटर,कीबोर्ड,must know,computer basic knowledge,accounting,excel shortcuts in hindi,shortcut keys,excel
Best regards,
The Office Crew
By Sachin Tanwar
6 сен 2024