Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
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 |
#2
|
|||
|
|||
Hi
use =NETWORKDAYS(A1,A2) Note: You must activate the Analysis toolpak Addin for using this function -- Regards Frank Kabel Frankfurt, Germany "Richard" schrieb im Newsbeitrag ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |