Subtracting Dates in Excel

June 5, 2009 at 04:50:46
Specs: Win XP Home, 2.2Ghz 512MB
Is there any way to disregard weekends and / or holidays when subtracting dates in Excel?

See More: Subtracting Dates in Excel

Report •


#1
June 5, 2009 at 05:36:02
Look at these 2 functions in Excel help:

NETWORKDAYS()
WORKDAYS()

Make sure you read the part about Holidays.


Report •

#2
June 5, 2009 at 07:11:53
The two functions that DerbyDad03 speaks of are part of the Analysis ToolPak
If you don't see them, then on the Tool Bar, Tools, Add-Ins, check mark the Analysis Toopak, click OK.
You will probably need your original install media.

MIKE

http://www.skeptic.com/


Report •

#3
June 5, 2009 at 07:16:41
Just to clarify, the both functions should be available in the Help files, but you might not be able to use them in a workbook until you install the Analysis Toolpak.

The Help files actually point this out.


Report •

Related Solutions

#4
June 5, 2009 at 07:25:37
Is there a way to make the NETWORKDAYS function work with an IF Statement? Such as:

If the NETWORKDAYS from L10 to M10 are <=4, then YES

I tried myself and it didn't quite work.


Report •

#5
June 5, 2009 at 08:10:53
This worked for me:

=IF(NETWORKDAYS(L10,M10)<=4,"Yes","No")


Report •

#6
June 5, 2009 at 08:42:33
Aha, I was putting an end bracket around <=4 instead of treating it separately.

Report •


Ask Question