Day count function

Hi Natalie,

Thank you for your question and welcome to the forum.

You can achieve this byusing the NetworkDays function.

The first thing you need to do is add a AddIn. Go to Tools - AddIns. Tick the checkbox for Analysis Toolpack and then click OK.

In a blank cell go to Insert Function and type NetworkDays in the Search box and then select it from the recommended functions in the box below and click OK.

In the Start Date enter the cell reference for later date and then in the End Date box the earliest date giving you a positive result.

I hope this answers your question.

Regards

Simon



.