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

Its working good. Thanks you very much for your help. Thanks, Krishnasamy M On Nov 24, 2016 3:25 PM, "Gowrisankar Arthanari GSA" <a.go...@gmail.com> wrote: > check the attachment.​ > > On Thu, Nov 24, 2016 at 11:19 AM, Krishnasamy.M <mrakul...@gmail.com> >

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

< a.go...@gmail.com> wrote: > 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 <mrakul...@gmail.com> > wrote: > >> Hi All, >&g

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

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

$$Excel-Macros$$ office 2010 file is currently in use. try again later error when saving

Hi all, Similarly I'm facing the subject issue on my Excel file. Kindly share you're experience and knowledge and solution. Note :-This workbook in shared folder. Thanks, Krishnasamy.M -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

Re: $$Excel-Macros$$ Need VBA code for Date format change

Thanks for you're reply and it's working. There is any way to do this via VBA for all cells in a columns. Thanks, Krishnasamy.M. On Jun 17, 2016 8:48 PM, "Paul Schreiner" <schreiner_p...@att.net> wrote: > Do you know if the cells contain actual DATES or if they are text st

$$Excel-Macros$$ Need VBA code for Date format change

Hi Experts, I have workbook with approx 300 rows.In this work book column A:A contain date with "dd.mm." format. Need to change this on "dd-mm-yy" Number format. Thank you for advance. Thanks, Krishnasamy.M -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d