Tag: excel
Spreadsheets: how to count weekdays between 2 dates
One of the things I often need to do is to calculate the number of work days between 2 dates in order to calculate billable days. There is a very useful function called NETWORKDAYS which does exactly this. It works the same in both Excel and Google Spreadsheets
The syntax is =NETWORKDAYS (start_date, end_date, [holidays])
example =NETWORKDAYS [...]
Posted: November 9th, 2009 under tips and tricks.
Tags: excel, google spreadsheets, tips and tricks
Comments: none