LinkBack URL
About LinkBacks
I got another issue too here...
Subtract these 2 dates, exclude Sundays & Holidays (in a list)
And I'm outside from US.
Eg:
DATE ISSUE DATE CLOSED
A B
21/1/2013 21/2/2013
14/2/2013 28/5/2013
Is someone could help me??
I got another issue too here...
Subtract these 2 dates, exclude Sundays & Holidays (in a list)
And I'm outside from US.
Eg:
DATE ISSUE DATE CLOSED
A B
21/1/2013 21/2/2013
14/2/2013 28/5/2013
Is someone could help me??
WORKDAY.INTL can help.
Quang PT
Shouldn't it be the NETWORKDAYS.INTL function ( the WORKDAY function adds days to a date)
Pl see attached file.
I've tried NETWORKDAYS.INTL function...but it still counting in US holidays.
Oh well, kvsrinivasamurthy...it works, however it still counts Sundays.
I just need Mondays to Saturdays (which exclude Sundays and holidays)
Could you please help me with this??
Last edited by husni; 02-19-2014 at 05:51 AM.
See my post no 4
I send the copy of mine.
I got another value for your calculation.
Could you please again help me with this kvsrinivasamurthy.
Formulas used are ARRAY Formulas.To enter ARRAY formula You Should press Ctrl+Shift+enter not only Enter keys.
Select C2 Press F2
Now Press Ctrl+Shift+enter
You Will se Flower Bracket around Formla.
Drag Down.
Now You Will get correct Result.
As you should enter the holidays yourself, I don't see why you are talking about US holidays? Check the function syntax to see how you can exclude SundaysOriginally Posted by husni
Last question for this thread.
what if:
DATE ISSUE DATE CLOSED
A B C
21/1/2013 21/2/2013 9 days
14/2/2013
The B2 is still no value (blank). Is there any additional to the formula???
Because i got #REF when no date at B2.
Can help me on this???
To avoid error result, use =IFERROR("Your Formula");"")
Accomplished.
TQVM azumi, Pepe & kvsrinivasamurthy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks