formula

R

Richard

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
 
N

Nick Turner

Hi Richard

You could try using this formula

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

Cheers

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Conditional Formatting - Given dates within certain range of days 4
Expanding Date Formula 0
Calculate end date and time 1
MS Project. Real progress of the project, % complete 1
Calculating days spent to complete a task 2
2016 Project, adding a workday to custom field 0
Formula to tell day of week 3

Top