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

...@gmail.comwrote: Thank you very much for the prompt reply Sir. - Original Message - *From:* ashish koul koul.ash...@gmail.com *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

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

. - Original Message - *From:* ashish koul koul.ash...@gmail.com *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)-NETWORKDAYS(A1,A2))/2

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

koul.ash...@gmail.com *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)-NETWORKDAYS(A1,A2))/2)+1 On Mon, Feb 14, 2011 at 6:04 PM, N

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

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

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

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

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

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 nalini.pradha...@gmail.comwrote: Dear Sir, Formula required for nos. of sundays between two days. e.g. if an employee has joined on 18/7/2010, how many