Its working good.
Thanks you very much for your help.
Thanks,
Krishnasamy M
On Nov 24, 2016 3:25 PM, "Gowrisankar Arthanari GSA"
wrote:
> check the attachment.
>
> On Thu, Nov 24, 2016 at 11:19 AM, Krishnasamy.M
> wrote:
>
>> Thanks for your Quick Response.
>>
>> My Requirement not Full fill
check the attachment.
On Thu, Nov 24, 2016 at 11:19 AM, Krishnasamy.M wrote:
> Thanks for your Quick Response.
>
> My Requirement not Full filled.
>
>
> May be my Understanding is wrong .Kindly Help for more Understanding.
>
> Detailed File Attached.
>
> Ans should be 15 Days
> Formula Ans is 9
Thanks for your Quick Response.
My Requirement not Full filled.
May be my Understanding is wrong .Kindly Help for more Understanding.
Detailed File Attached.
Ans should be 15 Days
Formula Ans is 92402 Days
Thanks,
Krishnasamy. M
On Thu, Nov 24, 2016 at 10:32 AM, Gowrisankar Arthanari GSA <
a
hi,
you can try this function
NETWORKDAYS.INTL(A2,B2,11,Holyday!$A$1:$A$13)
Regards,
A Gowrisankar
On Thu, Nov 24, 2016 at 7:32 AM, Krishnasamy.M wrote:
> Hi All,
>
> Good Day !!!
>
> Need Your support to get Net Ageing with below two conditions.
>
> (i).Excluded Sundays
> (ii) Excluded Holi