Re: $$Excel-Macros$$ Dates In Excel

I was only saying that it would be easier for people to remember 1=Sunday, 2=Monday, 3=Tuesday etc, and that one can rely on the default return_type (which is 1) without actually having to pass it in the function. Makes the formula look more comprehensible. :) Also, in your example below, =SUMPROD

Re: $$Excel-Macros$$ Dates In Excel

Dear SAM, I am agree with your statement.. and thanks for your valuable advice.. But if we use formula with little bit correction then we can find monday, tuesday count. it works similar to your formula... For Monday =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A16&":"&A17)),1)<2)) For Tuesday =

Re: $$Excel-Macros$$ Dates In Excel

Hey Noorain, what's up :) Similar methods used, but, just to touch-base on the differences, what I made use of is the fact that the default return_type of the WEEKDAY function is 1, and it also means that the first day is expected as a Sunday. So in effect, if you equate the resultant array to any

Re: $$Excel-Macros$$ Dates In Excel

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=1)) Where A1 and B1 are your start dates, and 1=Sunday, 2=Monday, 3=Tuesday etc Regards, Sam Mathai Chacko (GL) On Mon, Oct 10, 2011 at 10:57 PM, RockyFontane wrote: > I am trying to count the number of Sunday's between two date ranges. > For e

Re: $$Excel-Macros$$ Dates In Excel

Dear Rocky, Please try it..and see attached sheet.. *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C3&":"&D3)),2)>6)) *-- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Dates In Excel

I am trying to count the number of Sunday's between two date ranges. For example, Start Date: 9/25/2011; End Date: 10/24/2011. The number of Sunday's between these two dates are 5. What's the best way to write that in a formula? Thanks for your help! -- --

Re: $$Excel-Macros$$ Dates in Excel

Just replace the year from 2011 to 2010. by using replace all - Original Message > From: Rich Prince > To: MS EXCEL AND VBA MACROS > Sent: Thu, 26 May, 2011 6:49:10 PM > Subject: $$Excel-Macros$$ Dates in Excel > > I have a column of various dates that have the i

Re: $$Excel-Macros$$ Dates in Excel

Hi, You can select all the dates and use Control + H Find What: 2011 Replace With: 2010 then click on Replace All button. It will change all the 2011 to 2010 Hope this helps! Thanks, Shreedar On Thu, May 26, 2011 at 11:19 PM, Rich Prince wrote: > I have a column of various dates that have the

Re: $$Excel-Macros$$ Dates in Excel

Assuming that you r date is in Cell A1 Convert them with this formula: Formula in B1=Date(2010,Month(A1),Day(A1)) On Fri, May 27, 2011 at 12:49 AM, Rich Prince wrote: > I have a column of various dates that have the incorrect year, for > example: > > 9/1/2011 > 12/17/2011 > 10/31/2011 >

$$Excel-Macros$$ Dates in Excel

I have a column of various dates that have the incorrect year, for example: 9/1/2011 12/17/2011 10/31/2011 etc, etc... The year should be 2010 not 2011. Is there a quick remedy to correct this problem for several hundred dates? The Month and day are correct - just not the year. Any ideas? --