Formula

R

Richard

Is there a formula for working out the WORKING DAYS between two cells? For
instance if i had one date in A1 another in A2, could I in A3 work out simply
if the dates exceeded 7 Working days or not, must be working days not
consecutive days!!??

Thanks in advance, Richard
 
F

Frank Kabel

Hi
use
=NETWORKDAYS(A1,A2)

Note: You must activate the Analysis toolpak Addin for using this
function
 

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

Copy addition formula of non-consecutive horizontal cells 2
Conditional Formatting - Given dates within certain range of days 4
Expanding Date Formula 0
Percentage of month passed formula 1
Calculate end date and time 1
Difference between two date/time values 6
Formula to tell day of week 3
Help with an if then scenario 2

Top