Hi i have a formula that looks at days occupied in a month, how would I adjust this to just display the amount of workdays between 2 dates.
Key
F = Start Date
G = End Date
BB = Month and Year in Jun-2014 format
=IF($F4="","",MAX(0,MIN($G4,BB$3+31-DAY(BB$3+31))-MAX($F4,BB$3)+1))
Thanks in advance
JD
Hi
Your request is not clear(at least for me!)
A small sample workbook with the expected result will be useful.
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.
Why that BB3 is there?
just
wont be enough?PHP Code:=NETWORKDAYS(F4,G4)
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
Hi guys, here is a sample workbook.
The start and end dates can be anywhere between the FY start and end dates
Cheers
JD
give the intended result also pls in the sample workbook
NETWORKDAYS function gives a result of 261, that as i understand is not the expected result...
Which is the expected result in your example.
Here you go
JD
Good morning.
Here you go. In D5 and copy across.
Formula:
Please Login or Register to view this content.
Cheers Fotis, can you you quickly look at the sheet and put 07/07/14 in the year end (b1) the figure in D5 should read 5 but still shows the full 23 workdays.
Cheers
JD
Ok.
Formula:Please Login or Register to view this content.
Fantastic solution, much appreciated.
Cheers
JD
You are welcome and thanks for the feedback.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
There you go pal.
JD
Sorry Wrong Workbook
JD
Morning John.
This looks that do the job. Doesn't it?
Formula:Please Login or Register to view this content.
Hi Fotis eveything seems to work fine until you come to enter data for march april may etc, instead of calculating the actual amount required it just puts the full amount of workdays within that month, please see attached sheet with problem displayed.
Cheers
JD
Sorry for some reason it has posted twice.
JD
Ok John. Let's forget the multiply IF(AND...as we have to use many of them to get our results.
I was working on that when i saw your last reply. I ended up with this formula that testing many times looks that works pretty enough!!
Formula:Please Login or Register to view this content.
Cheers Fotis, love the simplicity of the new formula It works really well.
Thnaks for your help with this much appreciated.
Cheers
JD
..............................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks