200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi,
Please help me fro getting due date excluding holiday and sunday, i need on urgent basis as i spent lots of days to make the formula.
Start Date/Time Solve within hours Workday Start Workday End Holidays 24-10-2016 12:22 6 09:30:00 18:30:00 27-Oct-16 27-10-2016 08:57 28-10-2016 11:53 28-10-2016 17:18 28-10-2016 19:39 28-10-2016 21:52 28-10-2016 23:53 29-10-2016 02:11 29-10-2016 09:23 29-10-2016 09:34Thanks
Neeraj Kaushik
Checkout our Networkdays() tutorial. This tutorial also has a sample file that you can download to help you get started with the formula, but here is the basic syntax:
=NETWORKDAYS(start_date, end_date, [holidays])You can use the NETWORKDAYS() function along with the holidays argument.
In your case, since saturday should count as a "holiday" for you, just get a list of dates for the saturdays and include that in the list of holidays. There might be a better way to do this but that's just a quick thought.
Hi,.
See the attahced file , answar should be End Date/Time-29-10-2016 02:18:32 PM but it is coming 31-10-2016 02:18:32 PM, please help
Regards
Neeraj
8826618371