Function to Ignore Saturday and Sunday
Hi All,
Could some one please help me out with a function which can eliminate Saturday and Sunday.
For Example
If Date is 05th September 2008 and if i add two days it should show me 09th September 2008 (Ignoring Saturday and Sunday)
If Date is 05th September 2008 and if i add 7 days it should show me 16th September 2008 (Ignoring Saturdays and Sundays)
Use the Workday() function.
It is an Analysis Toolpak function...
Go to Tools|Addins and check Analysis Toolpak to install it.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Could i get a formula since we don't have access to add addins
Try:
Where A1 contains Date and B1 contains number of days to add
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks