Tag Archives: Working Days

Microsoft Excel – finding process date using working days from end date

If I have a date in which an order has to be sent and I know the number of working days that it takes me to process the order, I may want to find out when I need to start … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Excel – third working day of every month

Someone asked me recently whether they could produce a series in Excel to find out the third working day of every month. To be honest, it may be as easy to do this manually as you still need to input … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Excel – number of working days between two dates

The number of weekdays between two dates can be calculated using the Networkdays function. Click in the cell where the answer goes and then, on the Formula bar, click the Insert Function Fx button. The Insert Function dialog box will … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , | 1 Comment