Hello,
I need to have excel automatically calculate a variable which is assigned a starting value and increases by a constant every business day.
I assume that if weekend counted too it could work as follows: starting value + constant * days since starting date.
How could I make it exclude the weekend ?
Last edited by Crossover521; 06-09-2017 at 10:45 AM.
Take a look at =NETWORKDAYS()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You can use networkdays to work out the amount of days - weekends.
Example would be
=SUM(100+100)*NETWORKDAYS(B1,C1)
B1 contains start date and C1 contains end date.
This works. Thank you very much.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks