Hi Manjunath,
solved your query, please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Thu, Dec 13, 2012 at 8:45 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Hi experts,
>
>
>
> I want to calculate no of workdays and excludes holid
.com"
Sent: Thu, December 13, 2012 10:18:51 AM
Subject: $$Excel-Macros$$ Formula to Calculate Networkdays
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday
I tried using =Networkdays but I
use this one
=NETWORKDAYS(DATEVALUE("12/24/2012"), DATEVALUE("12/28/2012"),A:A )
Let Range A:A contains list of holidays
On Thu, Dec 13, 2012 at 8:47 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
>
>
> Hi experts,
>
>
>
> I want to calculate no of workdays and excludes hol
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday
I tried using =Networkdays but I was able to no of working days
Please help me to Exclude holiday.
Thanks
Manjunath
P
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday
I tried using =Networkdays but I was able to no of working days
Please help me to Exclude holiday.
Thanks
Manjunath
PL
