Re: $$Excel-Macros$$ help!!! creation code from data in cells

Hi, will you please provide the row data for the same query... thanks On Thu, Jan 2, 2014 at 11:07 PM, abhinav bansal wrote: > > > hi all i want to creat formula as defined below- > - > formula needed for creating Studen

Re: $$Excel-Macros$$ Need your help

Dear Kartik, Please elaborate more. On 03/01/2014, karthik N wrote: > Dear Friends > > Please find the attached file. > > Please help.. > > *Regards* > karthik.N > > -- > 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 official Facebook pa

Re: $$Excel-Macros$$ Date after weekend

Dear Ravinder Thanks a lot. The formula seems so simple, if only i had used my head. Again, thanks. Regards, Boreh On 3 January 2014 13:01, Ravinder wrote: > =IF(TEXT(date_rng,"ddd")="SAT",C60-1,IF((TEXT(date_rng,"ddd")="SUN"),date_rng-2,date_rng > )) > > Or pfa > > > > > > *From:* excel-macr

$$Excel-Macros$$ Workbooks consolidation

Hi visit to know how to consolidate workbooks. Workbook Consolidation. Thanks -- 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 official Facebook page of th

RE: $$Excel-Macros$$ Date after weekend

=IF(TEXT(date_rng,"ddd")="SAT",C60-1,IF((TEXT(date_rng,"ddd")="SUN"), date_rng -2, date_rng)) Or pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Robinson Boreh Sent: Friday, January 03, 2014 3:25 PM To: excel-macros Subject: $$Excel-Macros$$ Date

$$Excel-Macros$$ Date after weekend

Dear team. First happy new year. I need help. I have a formula on my excel, to which i add a number of days to give me a future date. My problem is, if the day falls on a weekend, it should show the next working day in this case a date on Monday. How can i achieve this. I don't want a date that fal