Dear all,
Please help me in setting up formula for counting number of holidays not week end for a specific period. Please note that I am using office 2010.
Thanks in advance!
Dear all,
Please help me in setting up formula for counting number of holidays not week end for a specific period. Please note that I am using office 2010.
Thanks in advance!
=NETWORKDAYS(Start_Date,End_Date)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
If your holidays are in a range, you could simply take the difference of the count the total workdays between two periods without and then with holidays.
Assumptions:
Range("A1") contains the start date
Range("A2") contains the end date
Range("A3:A12") contain the holidays (formatted as Date)
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
I attached an example with formulas.
Formula 3 is for the number of holidays that does not fall in the weekends.
So you don't need VBA
Kind regards,
Piet Bom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks