Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-17 Thread Rajasekhar Praharaju
to 02/16/20111 >> >> >> Thanks, >> Raj >> >> >> >> On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan >> wrote: >> >>> Thank you very much for the prompt reply Sir. >>> >>> >>> >>> ----- Origin

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-16 Thread ashish koul
h for the prompt reply Sir. >> >> >> >> - Original Message - >> >> *From:* ashish koul >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, February 14, 2011 8:17 PM >> *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days >

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-16 Thread Rajasekhar Praharaju
riginal Message - > > *From:* ashish koul > *To:* excel-macros@googlegroups.com > *Sent:* Monday, February 14, 2011 8:17 PM > *Subject:* Re: $$Excel-Macros$$ Nos. of Sundays between two days > > start date in a1 > > and end date in a2 > > no of sundays =INT(((A2-A1)-NETW

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-15 Thread N Pradhan
Thank you very much for the prompt reply Sir. - Original Message - From: ashish koul To: excel-macros@googlegroups.com Sent: Monday, February 14, 2011 8:17 PM Subject: Re: $$Excel-Macros$$ Nos. of Sundays between two days start date in a1 and end date in a2 no of

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-14 Thread ashish koul
start date in a1 and end date in a2 no of sundays =INT(((A2-A1)-NETWORKDAYS(A1,A2))/2)+1 On Mon, Feb 14, 2011 at 6:04 PM, N Pradhan wrote: > Dear Sir, > > Formula required for nos. of sundays between two days. > e.g. if an employee has joined on 18/7/2010, how many sundays between > 18/7/2010

$$Excel-Macros$$ Nos. of Sundays between two days

2011-02-14 Thread N Pradhan
Dear Sir, Formula required for nos. of sundays between two days. e.g. if an employee has joined on 18/7/2010, how many sundays between 18/7/2010 and 31/01/2011. Thanks & Regards. -- -- Some important links for exce