LinkBack URL
About LinkBacks
I've been working with this database that counts the number of days from the date assigned to date finished. I am using if isblank formula but i need to exclude the weekends
I've been working with this database that counts the number of days from the date assigned to date finished. I am using if isblank formula but i need to exclude the weekends
Need more info.
Maybe post a SMALL sample file so we can see what your data looks like.
A SMALL sample file will have about 20 rows and 2 or 3 columns worth of data.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Maybe this function will do it
=NETWORKDAYS(StartDate,EndDate)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I have found the formula = NETWORKDAYS(A1, TODAY()) but haven't tried it yet. thanks for your response!
Also, i need it to stop counting when the work has ended
Maybe something like this...
A1 = start date
B1 = end date (but this cell might be empty)
=NETWORKDAYS(A1,IF(B1="",TODAY(),B1))
Thanks tony. This almost solved my problem but it should start counting on the day after the start date
Hi tony, this is the formula ive been working on
=IF(ISBLANK(C2),today()-A2,C2-A2)
I need to exclude weekends
Try this...Originally Posted by jedaicore
=NETWORKDAYS(A1-1,IF(B1="",TODAY(),B1))
Still the same
You're going to have to show us some examples along with the expected results.
sample.xlsx
Here's my sample sheet.
1. No weekends included in the counting
2. Stops counting when the report has been completed
Thanks so much!
Can you provide more examples? 10 to 15 examples will help.
Also, manually enter the results you expect in column D. If the formulas are not retuning the results you expect then seeing those incorrect results doesn't help us. Better if you manually enter the results.
Hi Tony,
Thank you for your patience. Attached is the sample sheet. I entered the results manually as instructed.
thanks.
sample.xlsx
Using this formula I get the same results as the results you expect:
=NETWORKDAYS(A2+1,IF(C2="",TODAY(),C2))
Except on row 9. Your expected result is 12 but the formula returns 14.
I think if you double check the expected result you'll see that the correct result should be 14 which the formula does return.
Wow! This works like a charm. Thank you so much!!!!!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks