Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread NOORAIN ANSARI
Dear Sundar, Please try it.. Dear Sunder, You can also use.. =IF(WEEKDAY(A1)=6,"Sun","") On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote: > Dear friends, > > I need to find is the date in the cell is sunday > > 8/3/2012 10:30 8/3/2012 11:47 8/3/2012 10:26 8/3/2012 10:03 8/3/201

Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread Aindril De
Dear Sundervelan, Please Use =IF(TEXT(A2,"")="Sunday",1,"") Cheers, Andy On Fri, Aug 17, 2012 at 3:27 PM, Sundarvelan N wrote: > Please find the attached file for your reference. > > > Thanks > N.Sundarvelan > 9600160150 > > > > On Fri, Aug 17, 2012 at 3:13 PM, Manoj Kumar > wrote: > >> H

Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread Sundarvelan N
Please find the attached file for your reference. Thanks N.Sundarvelan 9600160150 On Fri, Aug 17, 2012 at 3:13 PM, Manoj Kumar wrote: > Hi Sundarvelan, > > Tri it.. > > =Text(a1,"ddd") > > Regard > Manoj > > > On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote: > >> >> Hi Sundarvelan, >> >>

Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread Manoj Kumar
Hi Sundarvelan, Tri it.. =Text(a1,"ddd") Regard Manoj On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote: > > Hi Sundarvelan, > > Please share a sample worksheet. > > Regards, > Kuldeep Singh > > > On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote: > >> Dear friends, >> >> I need to find

Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread Kuldeep Singh
Hi Sundarvelan, Please share a sample worksheet. Regards, Kuldeep Singh On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote: > Dear friends, > > I need to find is the date in the cell is sunday > > 8/3/2012 10:30 8/3/2012 11:47 8/3/2012 10:26 8/3/2012 10:03 8/3/2012 > 11:09 8/3/2012 1