ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula (https://www.excelbanter.com/excel-worksheet-functions/6277-formula.html)

Richard

formula

Is there a formula which calculates the WORKING DAYS between 2 dates, i.e. 1
date in A1 another in A2! Can i in A3 calculate the WORKING DAYS (not
weekends) between the 2 dates? I simply need the answer to be yes/no within
7 working days!!

Thanks in advance, Richard

Nick Turner

Hi Richard

You could try using this formula

=NETWORKDAYS("start date","end data","optional holidays")

Cheers

Nick

"Richard" wrote:

Is there a formula which calculates the WORKING DAYS between 2 dates, i.e. 1
date in A1 another in A2! Can i in A3 calculate the WORKING DAYS (not
weekends) between the 2 dates? I simply need the answer to be yes/no within
7 working days!!

Thanks in advance, Richard

All times are GMT +1. The time now is 09:22 AM.