I have a document that I need to keep track of the number of work days (5 a week) we go without an issue. I have it set up currently to count the number of days with a formula:
= today()-A1 with A1 holding the date of the last occurance. The issue with this is that it counts weekends.
Is there an easy way to calculate only work days?
Thanks,
Josh
=networkdays(a1,today())
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try:
=NETWORKDAYS(A1,TODAY())
will count workdays only
Quang PT
Try this...
=NETWORKDAYS(A1,TODAY())
Note that the NETWORKDAYS function requires the Analysis ToolPak add-in be installed if you're using a version of Excel prior to Excel 2007. If you enter the formula and get a #NAME? error look in Excel help for the NETWORKDAYS function. It'll tell you how to fix the problem.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks