Ignoring weekends when subtracting dates

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

i currently have 2 columns with 2 dates in them and i am subtracting one
from the other to find out the number of days between the 2, but i
would like to ignore weekends so it only takes into account mon-fri

is this possible :confused: ???

cheers:)
 
Robert,

Check out the NETWORKDAYS function. Got nothing to do with networks.
You'll need the analysis toolpak add-in (Tools - Addins).
 
Back
Top