[image: image.png] ... View more

Hi Team, I want a macro for study day of collection. In Every Domain we derive study day of collection like DMDY, AESTDY/AEENDY, EXSTDY,EXENDY etc.,. --DY = (date portion of --DTC) - (date portion of RFSTDTC) + 1 if --DTC is on or after RFSTDTC --DY = (date portion of --DTC) - (date portion of RFSTDTC) if --DTC precedes RFSTDTC Best Regards, K.Ajay ... View more

Hi team, Ok I will I am reframing the question. If a variable value has more than 500 characters and I have to split into 3 variables. Best Regards, K.Ajay ... View more

Hi Team, Please find the attachment of excel. Now I have to read the excel file and the order to be maintained the same. ... View more

Actually I was asked in an interview, You can consider any example which is in excel. Thanks in advance. ... View more

Thank you very much it worked in microsoft browser. But if i want in the chrome how will i get it. ... View more