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 •

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


Make sure you read the part about Holidays.

Report •

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.


Report •

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

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 •

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


Report •

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

Report •

Ask Question