I am using WORKDAY.INTL function in excel 2013.(not available for excel 2007)
And WORKDAY function in excel 2007 and 2013.
WORKDAY.INTL( start_date, days, [weekend], [holidays] )
I am using "11" for weekend. This means "sunday only" excluded.
But There is no any option to choose "sunday only" for WORKDAY function.
How can I use in excel 2007 version, WORKDAY function to choose "sunday only" for weekend.
Use the NETWORKDAYS.INTL function in Excel 2007. It should work the same as the WORKDAYS.INTL function you are using in 2013.
NETWORKDAYS.INTL is only available in Excel 2010 or later
Try this version to exclude Sundays only
=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))
where A1 is start date and B1 number of days to add
Audere est facere
Thanks a lot.Originally Posted by daddylonglegs
Working...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks