» excel http://robgray.org notes on social computing, innovation and business Fri, 09 Jul 2010 21:52:26 +0000 http://wordpress.org/?v=2.8.4 en hourly 1 Spreadsheets: how to count weekdays between 2 dates http://robgray.org/?p=317 http://robgray.org/?p=317#comments Mon, 09 Nov 2009 09:37:58 +0000 Rob Gray http://robgray.org/?p=317 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 (14/09/2009, 10/11/2009, 18/09/2009) gives you 41 days. In my example I only used one holiday but you can of course include multiple days in there.

bookmark and share... Digg del.icio.us Facebook Google Bookmarks LinkedIn Netvibes StumbleUpon TwitThis

]]> http://robgray.org/?feed=rss2&p=317 0