Hi,
This may be a complete shot in the dark, but at work I've built an Excel (obv) calculator to work out the benefits people get. For a certain group of people who are on fixed term contracts, their holiday is calculated by the amount of complete working weeks in that contract. Is there a way for Excel to work out the number of working weeks (mon-fri) in a contract if I were to add in the start and end dates? This would have to have some kind of calendar functionality as it would need to know what day the start and end dates are.
Any help much appreciated
Jon
Bookmarks