Re: $$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-24 Thread Krishnasamy.M
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

Re: $$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-24 Thread Gowrisankar Arthanari GSA
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

Re: $$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-23 Thread Krishnasamy.M
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 <

Re: $$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-23 Thread Gowrisankar Arthanari GSA
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

$$Excel-Macros$$ Net Ageing Formula Support Required

2016-11-23 Thread Krishnasamy.M
Hi All, Good Day !!! Need Your support to get Net Ageing with below two conditions. (i).Excluded Sundays (ii) Excluded Holiday -- *Thanks,Krishnasamy. MEmail: mrakul...@gmail.com | Phone:- +91 9095830577* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you