Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Subtracting Dates in Excel
Name: rickstyles Date: June 5, 2009 at 04:50:46 Pacific OS: Win XP Home CPU/Ram: 2.2Ghz 512MB Subcategory: Microsoft Office
Comment:
Is there any way to disregard weekends and / or holidays when subtracting dates in Excel?
Name: DerbyDad03 Date: June 5, 2009 at 05:36:02 Pacific
Reply:
Look at these 2 functions in Excel help:
NETWORKDAYS() WORKDAYS()
Make sure you read the part about Holidays.
0
Response Number 2
Name: Mike (by mmcconaghy) Date: June 5, 2009 at 07:11:53 Pacific
Reply:
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.
Name: DerbyDad03 Date: June 5, 2009 at 07:16:41 Pacific
Reply:
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.
0
Response Number 4
Name: rickstyles Date: June 5, 2009 at 07:25:37 Pacific
Reply:
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.
0
Response Number 5
Name: DerbyDad03 Date: June 5, 2009 at 08:10:53 Pacific
Reply:
This worked for me:
=IF(NETWORKDAYS(L10,M10)<=4,"Yes","No")
0
Response Number 6
Name: rickstyles Date: June 5, 2009 at 08:42:33 Pacific
Reply:
Aha, I was putting an end bracket around <=4 instead of treating it separately.
Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you want to see 03/14/2004 and paste in the formula. It c...
Summary: Hi, Please help me in comparing dates in Excel. Let the cells have dates as given below... A2 = 10-Jan-2009 B2 = 20-Feb-2009 C2 = 30-Mar-2009. I need a formula that checks if C2 is equal to an...
Summary: I have two different date where I want to know the no. of days, weeks, months and year. Is there any formula in Excel 2000 which can help me to solve this problem. Thanks ...
0 
