Formula

G

Guest

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
 
K

Kieran

Richard,

if you select the analysis toolpack addin, there is a function added t
excel =networkdays() that will do what you ask
 

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

Difference - except for Saturdays and Sundays 10
Formula 1
Comparison of columns using Conditional Formatting 3
Difference between two date/time values 5
determine workdays 1
days calculations 6
Formulas 3
number or working days 6

Top